Hi,

One possibility:
Create a helper list in two columns (say X1:X12, Y1:Y12) and populate them
with numbers and month/year-info (1 in X1 and Jan-05 in Y1,......10 in X10
and Oct-04 in Y10,...12 in X12 and Dec-04 in Y12). Now use the formula in,
say E2,

=VLOOKUP(MONTH(D2),$X$1:$Y$12,2)

Regards,
B. R. Ramachandran


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