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" <KathyC@discussions.microsoft.com> wrote in message
news:79019EC6-96D3-4149-AEE8-AED527D0CECF@microsoft.com...
> 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