How to derive Month number from Month text; Jan = 1 Feb = 2

[ThrottleWorks]

Hi,

I am trying get Month number from Month text using below mentioned formula.
For example Jan will be 1, Feb will 2 and so on.

Is there a better way to derive Month number. Can anyone please help me in this.

=IF(A2="Jan",1,IF(A2="Feb",2,IF(A2="Mar",3,IF(A2="Apr",4,IF(A2="May",5,IF(A2="Jun",6,IF(A2="Jul",7,IF(A2="Aug",8,IF(A2="Sep",9,IF(A2="Oct",10,IF(A2="Nov",11,IF(A2="Dec",12))))))))))))

 

[Deepak]

=MONTH(1&A2)

 

[ThrottleWorks]

Hi @Deepak sir, you are awesome ! Thanks a lot. Have a nice day ahead.

 

[Sudhir Prabhu]

=MONTH(1&A2)

Amazing Deepak.. what does the "1" signify in the syntax ?

 

[Nebu]

@Sudhir Prabhu
(1&A2) produces January 1, which the MONTH function evaluates as the date January 1 of the current year.

Thanks

 

[Syedali]

=MONTH(1&A2)

Excellent Bro