rolling 5 day work week calander

  • Thread starter Thread starter Dan Knighton
  • Start date Start date
D

Dan Knighton

I am needing to build a rolling 5 day work week calander.
I want it to always show the current work day first then
the next 4 work days. It needs to skip weekend days and
the list of holidays I have. I know it can be done but I'm
totally stumped. I can only make it do a 7 day rolling
calander and that won't work.

Dan
 
Hi Dan
let's say you want the dates in A1:A5 try the following:
A1:
=IF(WEEKDAY(TODAY(),3)>=5,WORKDAY(TODAY(),1,list_of_holidays),TODAY())
A2:
=WORKDAY(A1,1)
copy this down
 
Back
Top