Can any one advise me on the following.
How do I create a simple spreadsheet to return dates from a set criteria.

Example
I want to enter a start date, then the number of weeks of the period (i.e
26weeks)
This will return a date DD/MM/YY
I wouldalso like to be able to enter a offset figure of +/- 1,2, or 3 ....days
The offset criteria providing me with the date I want.
For Example
Date DD/MM/YY - 1 day ....etc
or
Date DD/MM/YY + 1 day.....etc

Question
The offset I could possible select from say a validation list?


Taking the spreadsheet a little further
How would I incorporate the periods in Weeks / Months / Years
For Example
Select Period from a Validation list....weeks or Months or Years
Enter a Start Date
Enter Number of Weeks / Months or Years I want to count ahead
Enter the offset number......the criteria to provide the date I want.

Any help would be great
Even if anyone can provide a sample .Xls that I could study would be
fantastic.

Thanks in advance