if "x" days is more fall on weekend return following monday
 

in A2:A366 i have every date of the year in mmddyyyy format

In B2:B366 i want it to return the date that is three days later.
unless it falls on a weekend. then it needs to be the following
monday.

For example:
A2 = 07/04/2006 B2 = 07/07/2006
A3 = 07/05/2006 B3 = 07/10/2006
A4 = 07/06/2006 B4 = 07/10/2006
A5 = 07/07/2006 B5 = 07/10/2006
A6 = 07/08/2006 B6 = 07/11/2006

I also want to make it is a format that cell C1 is where I put in the
amount of days later (so I can change it from 3 to 5 to 10, etc.)

Any suggestions.


--
jermsalerms
------------------------------------------------------------------------
jermsalerms's Profile: http://www.excelforum.com/member.php...o&userid=30167
View this thread: http://www.excelforum.com/showthread...hreadid=559108

if "x" days is more fall on weekend return following monday
 

=WORKDAY(A2,$C$1)

and copy down

WORKDY is part of the Analysis Toolpak, so that needs to be installed
(ToolsAddins)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"jermsalerms"
wrote in message
...

in A2:A366 i have every date of the year in mmddyyyy format

In B2:B366 i want it to return the date that is three days later.
unless it falls on a weekend. then it needs to be the following
monday.

For example:
A2 = 07/04/2006 B2 = 07/07/2006
A3 = 07/05/2006 B3 = 07/10/2006
A4 = 07/06/2006 B4 = 07/10/2006
A5 = 07/07/2006 B5 = 07/10/2006
A6 = 07/08/2006 B6 = 07/11/2006

I also want to make it is a format that cell C1 is where I put in the
amount of days later (so I can change it from 3 to 5 to 10, etc.)

Any suggestions.


--
jermsalerms
------------------------------------------------------------------------
jermsalerms's Profile:
http://www.excelforum.com/member.php...o&userid=30167
View this thread: http://www.excelforum.com/showthread...hreadid=559108

if "x" days is more fall on weekend return following monday
 

thank you this worked great


--
jermsalerms
------------------------------------------------------------------------
jermsalerms's Profile: http://www.excelforum.com/member.php...o&userid=30167
View this thread: http://www.excelforum.com/showthread...hreadid=559108

if "x" days is more fall on weekend return following monday
 

You say you want to return a date 3 days later unless it falls on the
weekend, in which case return following Monday. This isn't always the
same as adding 3 workdays and certainly won't ever be the same if C1 is
10

I suggest

=WORKDAY(A2+$C$1-1,1)


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=559108