| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do I calculate dates backwards from a project end date
In using Excel 2003 I am trying to build a schedule, starting backwards and
determining due dates based on timeframes, i.e. 6 months from completion date, 3 months from completion date, 6 weeks from completion date, etc. I am also trying to incorporate NETWORKDAYS minus holidays. Any help would be appreciated. Kathy |
|
#2
|
|||
|
|||
|
Use Workdays with a negative number of days
=WORKDAY(A1,-30,holidays) where holidays is a named range of holiday dates -- HTH Bob Phillips "KathyC" wrote in message ... In using Excel 2003 I am trying to build a schedule, starting backwards and determining due dates based on timeframes, i.e. 6 months from completion date, 3 months from completion date, 6 weeks from completion date, etc. I am also trying to incorporate NETWORKDAYS minus holidays. Any help would be appreciated. Kathy |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I calculate duration between two dates and times in excel? | Excel Discussion (Misc queries) | |||
| Calculate numbers between 2 dates | Excel Discussion (Misc queries) | |||
| Find project start and end dates in a DB with many different proje | Excel Worksheet Functions | |||
| formula to calculate # of days between dates, excluding holidays | Excel Discussion (Misc queries) | |||
| calculate with dates before 1-1-1900 | Excel Worksheet Functions | |||
Linear Mode
