converting month name to number
Responded in excel.misc.
=MONTH(DATEVALUE("01-"&A21))
--
HTH
Bob Phillips
(replace xxxx in the email address with gmail if mailing direct)
"runsrealfast" wrote in message
ups.com...
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?
|