If you have a "true", XL recognized date in a cell, and you wish to display
the month (or day), you can just format *that* cell, or any other cell to
display what you wish.

With
8/4/2005
in A1
You can format A1 to
mmmm
OR, in say B1, enter
=A1
And format B1 to
mmmm
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Shakespeare"
wrote in message
...

similarly to the first post I was trying to nest more than 7 statements,
which isn't working.

I have a column of dates, and I'm trying to calculate the date using
the Month function. However that function only returns a number and I
want to display the month written out.

Here's the way I was going:


=IF((MONTH(A3))=7,"July",IF((MONTH(A4))=8,"August" ,IF((MONTH(A19))=9,"Septem
ber",IF((MONTH(A23))=10,"October",IF((MONTH(A21))= 11,"November",IF((MONTH(A2
6))=12,"December",IF((MONTH(A11))=1,"January","
No Month")))))))

I was going to try the vlookup function, however this spreadsheet is
setup as a "list" and vlookup says the table must be sorted in
ascending order... which might not be the case.

There has got to be an easier way to do this.

Thank you

J


--
Shakespeare
------------------------------------------------------------------------
Shakespeare's Profile:
http://www.excelforum.com/member.php...o&userid=21552
View this thread: http://www.excelforum.com/showthread...hreadid=392766