RRS,

=TEXT(D2,"mmmyy")

HTH,
Bernie
MS Excel MVP


"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.