Calculate Start Dates based on Need-By Date?
I'm trying to calculate a start date based on a "need by" date. For instance.....cell B30 in a worksheet has a "need by" date of 5/4/2006. This date means I have to "start" the project 6 weeks before that. I'd like the formula to back-calculate the "start" date based on the "need by" date. I've tried using EDATE but get a "#NAME" error. I've tried =DATE92006,5,4) for the "need by" date but it still won't calculate backwards. Any help would be appreciated. Thanks a lot! |
Calculate Start Dates based on Need-By Date?
Just use
=B30 - 42 -- HTH Bob Phillips (remove nothere from email address if mailing direct) "GB" wrote in message news:1140545208.847450@sj-nntpcache-3... I'm trying to calculate a start date based on a "need by" date. For instance.....cell B30 in a worksheet has a "need by" date of 5/4/2006. This date means I have to "start" the project 6 weeks before that. I'd like the formula to back-calculate the "start" date based on the "need by" date. I've tried using EDATE but get a "#NAME" error. I've tried =DATE92006,5,4) for the "need by" date but it still won't calculate backwards. Any help would be appreciated. Thanks a lot! |
Calculate Start Dates based on Need-By Date?
Since 6 weeks = 42 days, just subtract 42.
=B30-42 HTH, Elkar "GB" wrote: I'm trying to calculate a start date based on a "need by" date. For instance.....cell B30 in a worksheet has a "need by" date of 5/4/2006. This date means I have to "start" the project 6 weeks before that. I'd like the formula to back-calculate the "start" date based on the "need by" date. I've tried using EDATE but get a "#NAME" error. I've tried =DATE92006,5,4) for the "need by" date but it still won't calculate backwards. Any help would be appreciated. Thanks a lot! |
All times are GMT +1. The time now is 09:49 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com