D
dcoleman
I need to change a five day workweek to a 6 day workweek. Or change
seven day to a six day.
Can I write a simple formula to link a basic 7 day week to a holida
schedule? I will list all of the Sundays on the Holiday tab.
the current formula I am using on a five day work week is:
=WORKDAY(B11,2,Holidays!$A$1:$A$24)
B11 is a start date and this cell adds 2 days to the start date.
The next cell adds 3 days to the new date.
This is so I can reuse the schedule over and over by entering a ne
start date.
I could use a simple formula like: =B11+2
but I can't seem to link it to the Holiday tab.
Can someone please help.
thanks, Da
seven day to a six day.
Can I write a simple formula to link a basic 7 day week to a holida
schedule? I will list all of the Sundays on the Holiday tab.
the current formula I am using on a five day work week is:
=WORKDAY(B11,2,Holidays!$A$1:$A$24)
B11 is a start date and this cell adds 2 days to the start date.
The next cell adds 3 days to the new date.
This is so I can reuse the schedule over and over by entering a ne
start date.
I could use a simple formula like: =B11+2
but I can't seem to link it to the Holiday tab.
Can someone please help.
thanks, Da