extract the month
Try
=TEXT(G2,"mmmm")
or
Custom format that to mmmm
If this post helps click Yes
---------------
Jacob Skaria
"Jim" 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
|