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.
|