excel question

[Mungorocks]

i've got an excel spreadsheet thats got a cell in it that displays todays date using the today() function.

is it possible to have another cell that gives todays() minus a month i.e. todays date is 07/02/2002 and i want this cell to say 07/01/2002.

can anyone help?

 

[acron]

If you have a date (or TODAY()) in A1, the following formula will add 1 month to that date.

=DATE(YEAR(A1),MONTH(A1)+1,DAY(A1))

You can choose to add Years, and even days by this method, though a simple + n will add n days to a date.

AC

 

[Mungorocks]

Cheers