Jim;456812 Wrote:
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

Hello Jim,

You can use TEXT function, i.e.

=TEXT(G2,"mmmm")


--
barry houdini
------------------------------------------------------------------------
barry houdini's Profile: http://www.thecodecage.com/forumz/member.php?userid=72
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=126439