extract the month

J

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
 
J

Jacob Skaria

Try
=TEXT(G2,"mmmm")

or
Custom format that to mmmm

If this post helps click Yes
 
B

barry houdini

Jim;456812 said:
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 mont
(August)
instead of the numbered month (8).

Can you help?
Thanks
Click to expand...

Hello Jim,

You can use TEXT function, i.e.

=TEXT(G2,"mmmm"
 
Top