converting Month name to a number

  • Thread starter Thread starter runsrealfast
  • Start date Start date
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?
 
How about:

=MONTH(DATEVALUE(A1&" 1"))

Where A1 holds that month string.
 
=MONTH(DATEVALUE("01-"&A21))

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)
 
If colomn A has month then try:

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

HTH
 
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 number 2
converting numbers to months 7
Convert Month Display 8
Function or formula to convert "text" month to number of month? 5
convert date to name of month 6
Tabulating a large list 2
Month Sales Problem 3
Converting numbers to month names 6

Back
Top