Excel Critical Path Schedule setup question

[tymbo]

Hi all, I work for a not for profit theatre and I'm trying to put together a calendar that shows the following:

- Show (as what the production name is)
- It's season start date
- A series of actions that need to be undertaken to ensure deadlines are met for marketing etc AND these actions need to occur in sequence working back from the show season start date.

For example, the mailout is to occur 4 weeks prior to the show start date, therefore the cell needs to calculate the date 4 weeks back from 'show start date' which is the ultimate / target date of course. There are a series of about 10 actions that need to occur and they all have set timeframes in place that work back from the show date.

The purpose of this spreadsheet is to have a resource that can be used on a weekly basis to show where things need to be for each show. I am using Excel 2003.

I appreciate any assistance on this, I for the life of me cannot work it out alone!!

Tim

[EdMac]

Hi Tim

If I understand you right you want a cell to have a date that is a predetermined number of days before your critical date.

If your critical date i.e the show start date is in cell A1 then using the formula

=A1-x

where X is the number of days before the critical date, will display the date to do it by.

If this is not the case, post back with more detail

[tymbo]

That's done the trick!! Thank you, that wasn't so painful at all =]