In Excel, look at a date field and return just the month..
 

I'm looking for an excel formula that looks at a cell containing a date and
returns just the month of the date.

Hi KC

here's some ideas for you

try
=MONTH(A1)

or

=A1
and then choose format / cell and in custom type
mmm
or type
mmmm

or
=text(A1, "mmm")

--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"KC" wrote in message
...
I'm looking for an excel formula that looks at a cell containing a date
and
returns just the month of the date.

To get the month #, i.e., 1 for Jan, 6 for Jun, use

=MONTH(cell with date)

If you want a text representation, i.e,. Jan or January for the 1st month, use

=TEXT(cell with date,"mmm")
or
=TEXT(cell with date,"mmmm")


"KC" wrote:

I'm looking for an excel formula that looks at a cell containing a date and
returns just the month of the date.