Forum Discussion

SGeisel1975's avatar
SGeisel1975
Copper Contributor
Jan 07, 2024

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

 

Meaning so far this year (in 2024) there has been 4 working days (January 1-7) - and as of Monday I would like that number then to automatically increase to 5.....and so on - until then end of the month is reached

 

Anyone know how I can do this?

 

Thanks so much

excel

8 Replies

  • HansVogelaar's avatar
    HansVogelaar
    MVP
    Jan 07, 2024

    SGeisel1975 

    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)

    • SGeisel1975's avatar
      SGeisel1975
      Copper Contributor
      Jan 07, 2024
      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

Resources