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")
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Mapping strings to integers 6
IF function says too many nested 1
Month (MMM) from date (dd/mmm/yy) 1
Lookup Formula 4
EXCEL COUNTING HELP 3
Value of the first day of a year in a list 5
If and LOOKUP - results in multiple columns 6
date format convert 3

Top