Skip to main content
S
shamima0001
February 3, 2023
Question

How to count number of working days in a month where Saturday & Sunday is a week-off

  • February 3, 2023
  • 1 reply
  • 0 views

I have a requirement to count number of working days in a month where Saturdays & Sundays are always week-off. Also, I need to substract national holidays like Christmas/ New Year etc.

Please help me with it.

    1 reply

    stefanhelzle0001
    stefanhelzle0001
    Brainy
    February 3, 2023

    You can use calworkdays() to get the number of working days between two dates. eomonth() gives you the date of the last day of a month. Combining that should give you the required result.

    Terms & ConditionsAccessibility statement