=CHOOSE(MONTH(TODAY()),12,1,2,3,4,5,6,7,8,9,10,11)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"MAB" wrote in message
...
This is my dilema... I need to display a status of 1 month previous and 2
months previous.

My problem arises in January and February. What I need in the statement
for
current month - 1 is: If month(today()) = 1, then 12, else
month(today())-1.
What I need for the statement current month -2 is: If(month(today()) =
1,
then 11, If month(today())= 2, then 12, else month(today())-2. I'm just
not
certain how to write this in Excel.

Thank you.