formula for prior month & year of a month end date.

[mikeburg]

I need a formula to return the prior month & year based on a month end date.

For example:

In Cell D2: 08-31-07 & cell D2 is formatted for mm/dd/yy

In Cell L18: =TEXT(D2, "mmm") & RIGHT(YEAR(D2),2)

Returns: Aug07

I need: Jul07

For:
01-31-07 need Dec06
02-28-07 need Jan07
03-31-07 need Feb07
etc

Thanks a million for all your help so far. mikeburg

[Richard Schollar]

Hi Mike

How about:

=TEXT(DATE(YEAR(D2),MONTH(D2),0),"mmmyy")

Richard

[mikeburg]

works great!

Thank you for your help. mikeburg