converting Month name to a number

R

runsrealfast

I 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

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

--

HTH

Bob Phillips

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

Toppers

If colomn A has month then try:

=MONTH(DATEVALUE("01/" & A1 & "/2006")) and copy down

HTH
 
Top