I work for a company that puts on trade and consumer shows.
I would like to set up a spreadsheet to create a calendar for all the
shows.

There are certain tasks that need to be done for every show 1 year
out, 6 months out, 3 months out, 4 weeks, 2 weeks, 10 days, etc etc

I am thinking of having the first sheet in the workbook listing all
the shows with their dates.

Based on the date of the show, I would like Excel to list tasks that
need to be done.

1 year out... task 1
6 months out.....task 2
4 months out...task 3
3 months out..task 4
1 month out...task 5
1 week out...task 6
etc etc

I will create a list of the tasks, I just want Excel to calculate the
dates each task needs to be completed based on the date of the show.

I think I want one sheet for all tasks and their due dates because we
are often working on multiple events at the same time.

So far I have:

Sheet 1

Event start date end date
event #1
event #2
event #3
event #4

Sheet 2

task 1 event 1 event 2 event 3 event 4
task 2 event 1 event 2 event 3 event 4
task 3 event 1 event 2 event 3 event 4
task 4 event 1 event 2 event 3 event 4
task 5 event 1 event 2 event 3 event 4

etc etc

As I have it now I would like Sheet 2 to enter the due date for each
task based on the starting date of the event (found in Sheet 1) and
how far in advance of the start date it needs to be done.

For task 1 event 1, I was thinking of entering (=Sheet 1, B2-6 months)
For task 1 event 2, I was thinking of entering (=Sheet 1, B3-6 months)
(with the proper formatting of course, which I do not know right now)
etc etc

If I set this up with the tasks that need to be done for every show,
then as soon as I enter an event and the dates, I should have a
complete work plan for the show!

If you read all of this, thank you!!
Thanks for any and all input.

....Lisa