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

dcoleman wrote:
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

Hi Dan,

using WORKDAY you don't need to list Sundays or Saturdays as Holidays,
because the function itself doesn't count them. In the Holidays list you
have to list all other holidays (Christmas, Easter and other holidays in
your part of the world...).


--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy