R
RRS from Connecticut
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",IF(MONTH(D2)=1,"Jan05",IF(MONTH(D2)=2,"Feb05",IF(MONTH(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.
statments can be nested 7 times.
Eg of my data and formula:
=IF(MONTH(D2)=10,"Oct04",IF(MONTH(D2)=11,"Nov04",IF(MONTH(D2)=1,"Jan05",IF(MONTH(D2)=2,"Feb05",IF(MONTH(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.