Subtract 1 month from date

[JPHenning]

Hi

I need help with a formula

I am using =Today() to have a changing date in A1 cell

then in the cell A2 under i need exactly 1 month before, is there a formula that will put this date in.

Obviously I can't use =(A1-31) as there are not always 31 days in the month

Please help

 

[VoG]

Try

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