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 ...
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?
You're correct - I hadn't taken that into account.
I modified the formula in the attached workbook.
- Hello Hans
That worked perfectly - thank you very much!