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 ...
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.
Hi Hans
The file you sent me worked great - but now we are in the first working day of February - it switched to February correctly - there is now 1 working day in February - but January is still counting
January is now at 23 working days - where it should have stopped at 22
Even in the file you sent me - you will see January at 23 and February at 1
What would be the fix for this?