extract the month

[Jim]

Hello,

I'm using the following to extract the month from a date: =MONTH(G2). I
can't seem to figure out how to get it to show the actual month (August)
instead of the numbered month (8).

Can you help?
Thanks

 

[Jacob Skaria]

Try
=TEXT(G2,"mmmm")

or
Custom format that to mmmm

If this post helps click Yes

 

[Max]

Maybe you could use this instead: =TEXT(G2,"mmm")
which will directly extract the month from the date in G2 as text, eg: Aug

aha? hit the YES below
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik