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!

Just use

=B30 - 42

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"GB" <(E-Mail Removed)> 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!
>
>

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!
>
>
>