converting month name to number

  • Thread starter Thread starter runsrealfast
  • Start date Start date
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?
 
Responded in excel.misc.

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

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)
 
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
 
You must log in or register to reply here.

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

converting Month name to a number 3
Mapping strings to integers 5
Help required on Tabulating monthly expenses for the Current Month,Previous Month and Month previous 12
Vlookup or Hlookup does not work 1
convert number to month and year in formula 3
Converting month name to number 8
multiple criteria count formula with duplicate data 10
Formula to count based on multiple criteria fields w/duplicates 5

Back
Top