rolling 5 day work week calander

[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

 

[Frank Kabel]

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