Perfect OssieMac!!
Thank you!!

Is there a way tro modify the formulas so the dates fall only on Mon-
Fri....

....Lisa

On Sep 30, 8:23 pm, OssieMac
wrote:
Hi Lisa,

I'll give you some formulas and perhaps you will be able to work it out from
there. All of the formulas assume that the event date is in cell A2 and each
formula is spread across the page from there.

Event date in cell A2 is 27 Oct 2008.

Year 1: =DATE(YEAR(A2)-1,MONTH(A2),DAY(A2))
6 Months: =DATE(YEAR(A2),MONTH(A2)-6,DAY(A2))
3 Months: =DATE(YEAR(A2),MONTH(A2)-3,DAY(A2))
4 Weeks: =DATE(YEAR(A2),MONTH(A2),DAY(A2)-28)
2 Weeks: =DATE(YEAR(A2),MONTH(A2),DAY(A2)-14)
10 Days: =DATE(YEAR(A2),MONTH(A2),DAY(A2)-10)

Year 1 returns 27 Oct 2007.
6 Months returns 27 Apr 2008.
3 Months returns 27 Jul 2008.
4 Weeks returns 29 Sep 2008. (Note formula subtracts 28 days)
2 Weeks returns 13 Oct 2008. (Note formula subtracts 14 days)
10 days returns 17 Oct 2008.

If you look up Date function in help then I am sure you will work out what
the formulas are doing

Feel free to get back to me if you need more information.

Regards,

OssieMac