In A11 use

=A12-1+(A12=1)*12

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"DavidS" wrote in message
...
Hello, I am trying to create a column staring with the present month in
A12,
going back 12 months to A1. I always want the present month to be in A12
and
then have the previous months going back to A1. I can use MONTH(TODAY())
to
get the month number and use a lookup for the actual month in A12. The
problem I have is that I can't think of a way to go back from January to
December. If I keep reducing the month number, I reach 0, which is not
valid
i.e. A12 contains October and A3 January - I need to be able to put
December
in A2 and have the column update and rollback when the month changes.
Thanks