=TEXT(A1,"mmm")&"04"

but probably this suits you better:

=TEXT(A1,"mmm")&TEXT(A1,"yy")

--
Kind regards,

Niek Otten

Microsoft MVP - Excel

"RRS from Connecticut" <RRS from
wrote in message ...
I am trying to show 12 month names from dates, but can show only 8 since if
statments can be nested 7 times.
Eg of my data and formula:
=IF(MONTH(D2)=10,"Oct04",IF(MONTH(D2)=11,"Nov04",I F(MONTH(D2)=1,"Jan05",IF(MONTH(D2)=2,"Feb05",IF(MO NTH(D2)=3,"Mar05",IF(MONTH(D2)=12,"Dec04",IF(MONTH (D2)=4,"Apr05")))))))
I need to join the if statment to show the rest of the months.
Thanks.
RRS.