Now() minus 1 month = ?

[Tom Wagner]

Hello - I'm trying to find out how to display a date of 1 month prior to current month year. If today is Oct-04, I would like to display Sept-04 in a cell.
Thanks for any help.
Tom

 

[Corni]

Juan formula works most of the time except Jan dates, when the year changes for the previous date, i.e. Year(A2)-1 should be used.

 

[tusharm]

Did you try it? What result did you get?

Juan formula works most of the time except Jan dates, when the year changes for the previous date, i.e. Year(A2)-1 should be used.

 

[fairwinds]

Look at Paddy's suggestion in the beginning of this thread. It will handle also January dates.

 

[Juan Pablo González]

Look at Paddy's suggestion in the beginning of this thread. It will handle also January dates.

Quoting Tushar... "Did you try it ?"

 

[fairwinds]

Sorry Juan, was posting in haste

Was actually thinking of dates like March 30, that is where the results from the 2 formulas differ.