| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Exclude Weekends
How do I set up the calander to exclude weekends in my schedule calculation?
Est Start Date 04/01/2010 Leadtime = 5 days Actual start date is 09/01/2010 which is a Saterday. It would be great to change the act start dte to 08/01/2010 Friday. Tx. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Exclude Weekends
JJ,
What day would you want to return if the calculated start date was a Sunday? Mike "JJ" wrote: How do I set up the calander to exclude weekends in my schedule calculation? Est Start Date 04/01/2010 Leadtime = 5 days Actual start date is 09/01/2010 which is a Saterday. It would be great to change the act start dte to 08/01/2010 Friday. Tx. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Exclude Weekends
Hi
Assuming you have the Analysis Toolpak loaded (ToolsAddinAnalysis Toolpak) then with you starting date in A1 =workday(A1-1,5) will return a Friday for dates falling on a Friday, Saturday or Sunday. -- Regards Roger Govier "JJ" wrote in message ... How do I set up the calander to exclude weekends in my schedule calculation? Est Start Date 04/01/2010 Leadtime = 5 days Actual start date is 09/01/2010 which is a Saterday. It would be great to change the act start dte to 08/01/2010 Friday. Tx. __________ Information from ESET Smart Security, version of virus signature database 4741 (20100104) __________ The message was checked by ESET Smart Security. http://www.eset.com __________ Information from ESET Smart Security, version of virus signature database 4741 (20100104) __________ The message was checked by ESET Smart Security. http://www.eset.com |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Exclude Weekends
Hi Mike
if the start date is Saterday then return to Friday. If Sunday, return to Monday. JJ "Mike H" wrote: JJ, What day would you want to return if the calculated start date was a Sunday? Mike "JJ" wrote: How do I set up the calander to exclude weekends in my schedule calculation? Est Start Date 04/01/2010 Leadtime = 5 days Actual start date is 09/01/2010 which is a Saterday. It would be great to change the act start dte to 08/01/2010 Friday. Tx. |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Exclude Weekends
Hi,
date in a1 days to add in B1 =A1+B1-CHOOSE(WEEKDAY(A1+B1,2),0,0,0,0,0,1,-1) Mike "JJ" wrote: Hi Mike if the start date is Saterday then return to Friday. If Sunday, return to Monday. JJ "Mike H" wrote: JJ, What day would you want to return if the calculated start date was a Sunday? Mike "JJ" wrote: How do I set up the calander to exclude weekends in my schedule calculation? Est Start Date 04/01/2010 Leadtime = 5 days Actual start date is 09/01/2010 which is a Saterday. It would be great to change the act start dte to 08/01/2010 Friday. Tx. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Date count to exclude weekends | Excel Worksheet Functions | |||
| Exclude Weekends | Charts and Charting in Excel | |||
| Exclude weekends when counting days only on day 29 or 30 | Excel Worksheet Functions | |||
| How do I set up a calculation to exclude weekends? | Excel Worksheet Functions | |||
| calculation to exclude weekends | Excel Worksheet Functions | |||
Linear Mode
