Skip to main content
Known Participant
Feb 3, 2023 3:13 PM UTC
Question

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

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
    Brainy
    Feb 3, 2023 3:24 PM UTC

    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.