| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Date calculation
I have an end date in mind for training, and the number of days the training
is supposed to last. Is there a formula to determine the start date minus weekends? Example, training must be completed by May 1, 2009, and the training is supposed to last 10 working days, what should the start date be? I'm using Excel 2003 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Date calculation
With completion date in cell A1 and number of working days in cell B1 ;try
the below formula..Points to be noted 1. Incase this formula returns a #VALUE! error you need to install ATP. To install; from menu ToolsAddIns check 'Analysis ToolPak' and hit OK. 2. Format the formula cell to excel date format =WORKDAY(A1,-B1+1) If this post helps click Yes --------------- Jacob Skaria "Jessica" wrote: I have an end date in mind for training, and the number of days the training is supposed to last. Is there a formula to determine the start date minus weekends? Example, training must be completed by May 1, 2009, and the training is supposed to last 10 working days, what should the start date be? I'm using Excel 2003 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| A specific date used for calculation of a new date | Excel Discussion (Misc queries) | |||
| Date Calculation (from entered date / 1yr later in next field) | Excel Worksheet Functions | |||
| Date Calculation | Excel Discussion (Misc queries) | |||
| End Date Calculation (adding a start date duration) | Excel Discussion (Misc queries) | |||
| Tricky Date calculation: How to calculate a future date | Excel Discussion (Misc queries) | |||
Linear Mode
