So what results do expect if A = January?

--
Biff
Microsoft 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.