converting month name to number

R

runsrealfast

would like to convert a column that holds the name of a month
(January, February, etc) into a number (1, 2). Is there an easy way to
do this, you can't do enough if statemnts to do that. any suggestions?
 
B

Bob Phillips

Responded in excel.misc.

=MONTH(DATEVALUE("01-"&A21))

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)
 
R

Ron Rosenfeld

would like to convert a column that holds the name of a month
(January, February, etc) into a number (1, 2). Is there an easy way to
do this, you can't do enough if statemnts to do that. any suggestions?
Click to expand...

Here's one way:

=TEXT(DATEVALUE("1 " &A1&" 2000"),"m")



--ron
 
Top