I need to change a five day workweek to a 6 day workweek. Or change a
seven day to a six day.

Can I write a simple formula to link a basic 7 day week to a holiday
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 new
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, Dan


--
dcoleman
------------------------------------------------------------------------
dcoleman's Profile: http://www.excelforum.com/member.php...o&userid=37205
View this thread: http://www.excelforum.com/showthread...hreadid=569210