Dates

[kingdt]

What i need to do is have 3 cells automatically update from a date specified in another cell. One cell would always show 2 months before the date, another cell would show 1 month before the date and the other cell would show the same date as the cell (last one is easy enough).

So if in Cell A1 i put 01/04/07, then cell C1 would automatically show 01/02/07 and cell C2 would automatically show 01/03/07. If i change the date in cell A1, Cells C1 & C2 would always show two and one months before that date.

Is there a formula that i could use to do this???

Thanks in advance

[sweep]

If your date is in E7,

=DATE(YEAR(E7),MONTH(E7)-1,DAY(E7))

will give you a month prior

and

=DATE(YEAR(E7),MONTH(E7)-2,DAY(E7))

will give you two months prior

hth

Dave

[kingdt]

Many thanks Sweep, works a treat