Oops. I missed the minus 1.

=IF(MONTH(A1)=1,"Dec",TEXT(MONTH(A1)-1&"/1/2006","mmm"))


"PCLIVE" wrote in message
...
It seems that you could also just use:

=TEXT(A1,"mmm")


"HearSay" wrote in message
...
I have a cell that I would like to display the three letter month minus a
month based on the current day
So today is 09/29/2006, I would like the cell to contain "Aug"

Is this possible.