If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Calculate Date
Can an add function be tweaked to compute a date value that does not equal a
Saturday or Sunday. Example: Start date = 4/17, days added = 2, answer = 4/19 which is a Sunday. Desired answer is 4/20 which is a Monday. |
#2
|
|||
|
|||
Calculate Date
Try this:
A1 = 4/17/2009 B1 = 2 If the result you expect is Monday then that means you're counting the start date. =WORKDAY(A1-1,B1) Format as Date The WORKDAY function requires the Analysis ToolPak add-in be installed in Excel versions prior to Excel 2007. -- Biff Microsoft Excel MVP "brownmre" wrote in message ... Can an add function be tweaked to compute a date value that does not equal a Saturday or Sunday. Example: Start date = 4/17, days added = 2, answer = 4/19 which is a Sunday. Desired answer is 4/20 which is a Monday. |
#3
|
|||
|
|||
Calculate Date
Try
=A1+2+IF(WEEKDAY(A1+2,2)5,8-WEEKDAY(A1+2,2),0) with Start date in A1 "brownmre" wrote: Can an add function be tweaked to compute a date value that does not equal a Saturday or Sunday. Example: Start date = 4/17, days added = 2, answer = 4/19 which is a Sunday. Desired answer is 4/20 which is a Monday. |
#4
|
|||
|
|||
Calculate Date
Look in Excel help at the function WORKDAY
-- David Biddulph "brownmre" wrote in message ... Can an add function be tweaked to compute a date value that does not equal a Saturday or Sunday. Example: Start date = 4/17, days added = 2, answer = 4/19 which is a Sunday. Desired answer is 4/20 which is a Monday. |
#5
|
|||
|
|||
Calculate Date
Thanks Sheeloo. It works great.
"Sheeloo" wrote: Try =A1+2+IF(WEEKDAY(A1+2,2)5,8-WEEKDAY(A1+2,2),0) with Start date in A1 "brownmre" wrote: Can an add function be tweaked to compute a date value that does not equal a Saturday or Sunday. Example: Start date = 4/17, days added = 2, answer = 4/19 which is a Sunday. Desired answer is 4/20 which is a Monday. |
#6
|
|||
|
|||
Calculate Date
You are welcome.
Try Biff's solution too... it is more elegant. =WORKDAY(A1-1,2) or =WORKDAY(A1,2) "brownmre" wrote: Thanks Sheeloo. It works great. "Sheeloo" wrote: Try =A1+2+IF(WEEKDAY(A1+2,2)5,8-WEEKDAY(A1+2,2),0) with Start date in A1 "brownmre" wrote: Can an add function be tweaked to compute a date value that does not equal a Saturday or Sunday. Example: Start date = 4/17, days added = 2, answer = 4/19 which is a Sunday. Desired answer is 4/20 which is a Monday. |
#7
|
|||
|
|||
Calculate Date
It depends on what their exact requirements are.
Our formulas return different results depending on the weekday of the date. -- Biff Microsoft Excel MVP "Sheeloo" wrote in message ... You are welcome. Try Biff's solution too... it is more elegant. =WORKDAY(A1-1,2) or =WORKDAY(A1,2) "brownmre" wrote: Thanks Sheeloo. It works great. "Sheeloo" wrote: Try =A1+2+IF(WEEKDAY(A1+2,2)5,8-WEEKDAY(A1+2,2),0) with Start date in A1 "brownmre" wrote: Can an add function be tweaked to compute a date value that does not equal a Saturday or Sunday. Example: Start date = 4/17, days added = 2, answer = 4/19 which is a Sunday. Desired answer is 4/20 which is a Monday. |
Thread Tools | |
Display Modes | |
|
|