MONTH() Function

[Edge118]

In cell G2 I have a date. In cell H2 I am using =Month(G2) to store th
month in H2. Since Excel returns a serial number, how can I have i
display the month instead of a number? I've tried messing with th
formats but it doesn't help...it only display Jan when I change th
format to "mmm".

R

 

[Peo Sjoblom]

Either link the cell =G2 and format the cell as mmm or
use

=TEXT(G2,"mmm")

--
For everyone's benefit keep the discussion in the newsgroup.

Regards,

Peo Sjoblom

 

[Jason Morin]

Don't use MONTH. Use this in H2:

=TEXT(G2,"mmm")

or simply use:

=G2

and custom format G2 as "mmm".

HTH
Jason
Atlanta, GA

 

[jeff]

Hi,

Format as custom; "mmmmmm" - you'll get 'January'

jeff

 

[Paulw2k]

=TEXT(G2,"mmmm") for the full name eg June
=TEXT(G7,"mmm") for the short name eg Jun