help with date funciton

D

dlotz

is there a funciton that will return only the name of the month. IE
COL A COL B
12/3/2009 December
3/4/2007 March
and so on
 
N

Niek Otten

Yes. Format the cell as Custom, in the Type box, enter "mmmm" (withour the
quotes)
 
B

Bob Umlas

in column B simply refer to column A and format col B as "mmmm"
So B2 has =A2 and is formatted as "mmmm".
Bob Umlas
Excel MVP
 
G

Glenn

is there a funciton that will return only the name of the month. IE
COL A COL B
12/3/2009 December
3/4/2007 March
and so on
Click to expand...


If you actually want the text "March" instead of a date formatted to show
"March", use the TEXT() function:

=TEXT(A1,"mmmm")
 
Top