Excel formula help _ Get month number from Month Name.

[pedie]

Hi, is there a way for Excel formula to Get month number from Month Name.
1 for Jan etc
maybe choose, lookup etc...

Thanks for helping....

I have january in A1, i want result 1 in B1

 

[barry houdini]

Try this formula

=MONTH(1&A1)

 

[T. Valko]

Hi, is there a way for Excel formula to Get month number from Month Name.
1 for Jan etc
maybe choose, lookup etc...

Thanks for helping....

I have january in A1, i want result 1 in B1

This works in my location (U.S.)...

=MONTH(A1&1)

 

[JackDanIce]

Try:

=MATCH(UPPER(A1),{"JANUARY","FEBRUARY","MARCH","APRIL","MAY","JUNE","JULY","AUGUST","SEPTEMBER","OCTOBER","NOVEMBER","DECEMBER"},0)

 

[CWatts]

Depending on how you're using it, but here's somethign basic to illustrate what you want, but it can be easily cleaned up with named ranges and the like.

This will work if it is just text

=MATCH(A1,{"January";"February";"March";"April";"May";"June";"July";"August";"September";"October";"November"},0)

If it's a serial date, you can use =MONTH(A1)

 

[pedie]

Perfect works great for me too....
Why "&1" is there any logic behind that, if i may ask?

 

[pedie]

JackDenice and JackDanIce...thanks for the reply and showing the other approach....

Regards
Pedie

 

[JackDanIce]

You're welcome

 

[T. Valko]

Perfect works great for me too....
Why "&1" is there any logic behind that, if i may ask?

Excel is extremely "eager" to recognize a date entry.

If A1 contains some month name like January, then concatenating 1 like A1&1 produces January1 which the MONTH function evaluates as the date January 1 of the current year (January 1 2011).

 

[pedie]

Great! thanks again...makes sense...