Forum Discussion
Working Days Help
I know that there are 22 working days in January 2024 (Canada based on National Holidays) What I want to do is have a live running total of current Year to Date - or Month to Date working day ...
Create a list of national holidays in Canada in 2024 (or beyond).
Select the list, then click in the name box on the left hand side of the formula bar, type Holidays and press Enter. You have now named the list.
In the cell where you want the year-to-date running total, enter the formula
=NETWORKDAYS(DATE(YEAR(TODAY()), 1, 1), TODAY(), Holidays)
For the month-to-date total, use
=NETWORKDAYS(DATE(YEAR(TODAY()), MONTH(TODAY()), 1), TODAY(), Holidays)
That worked great thank you very much!
Now - can I have my list of months.......and my counter counting only for the month its in - and when that month is complete - it will automatically start counting for the next month?
For example....
January is at 4 currently
February 0
March 0
and so on
At the end of January - it should reach 22 working days....great - but then I want it to go to February and start that count all over
For example
January 22
February 5
March 0
And so on
Then I can just use an Auto Sum feature to show the total working days YTD
I hope I am making sense
Now - can I have my list of months.......and my counter counting only for the month its in - and when that month is complete - it will automatically start counting for the next month?
For example....
January is at 4 currently
February 0
March 0
and so on
At the end of January - it should reach 22 working days....great - but then I want it to go to February and start that count all over
For example
January 22
February 5
March 0
And so on
Then I can just use an Auto Sum feature to show the total working days YTD
I hope I am making sense
See the attached demo workbook.
- Thank you so much - this worked great!
Now that I have this up and running - it will be simple to change this to future years
Very much appreciated!You only need to update (or expand) the Holidays range.