Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need cell formulas to return the day of every Monday in a month based on year entered | Excel Discussion (Misc queries) | |||
Desperately need help with 3 calculations | Excel Worksheet Functions | |||
Search a random array of cells and return a value of "X" | Excel Worksheet Functions | |||
Return only work days | Excel Discussion (Misc queries) | |||
Date Calculations | Excel Worksheet Functions |