=TEXT(DATE(YEAR(NOW()),MONTH(DATEVALUE(A1&" 1, " & YEAR(NOW())))-1,1),"MMMM")
=TEXT(DATE(YEAR(NOW()),MONTH(DATEVALUE(A1&" 1, " & YEAR(NOW())))-2,1),"MMMM")
=TEXT(DATE(YEAR(NOW()),MONTH(DATEVALUE(A1&" 1, " & YEAR(NOW())))-3,1),"MMMM")

HTH,
Bernie
MS Excel MVP


"wx4usa" wrote in message
...
I have column A with the text string "September" and I need to have
column B show "September" minus 1 month or "August". Column C "July"
and D "June"

Then next month column A will change to October and B,C&D will move up
a month.

Make sense???
Thanks in advance for your help.