|
| 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
April 15th, 2009, 06:14 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
April 15th, 2009, 06:26 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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
April 15th, 2009, 06:32 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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
April 15th, 2009, 06:35 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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
April 15th, 2009, 07:26 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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
April 15th, 2009, 08:25 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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
April 15th, 2009, 09:05 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 | |
|
|
Linear Mode
