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.