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