The beauty of simplicity!

--
Kind regards,

Niek Otten

Microsoft MVP - Excel

"Roger Govier" wrote in message
...
Just to add another variation to the answers already received from Bernie
and Niek, you could just format cell D2 (and the rest of the column if
required) as

Format CellsNumberCustom mmmyy

Regards

Roger Govier


RRS from Connecticut wrote:
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.