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 |
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 |
All times are GMT +1. The time now is 05:24 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com