Excel Formula MMM to int
Is there an excel formula that converts text months in short date format to their numeric value?

Example: Jan = 1, Feb = 2, ect.
I'm familiar with showing the numbers as text via =TEXT(1,"MMM") but not the other way around for these text values.

Right now I'm using an If function nested 12 deep, which just looks ugly.
Excel Formula MMM to int
===

Is there an excel formula that converts text months in short date format to their numeric value?

Example: Jan = 1, Feb = 2, ect.
I'm familiar with showing the numbers as text via =TEXT(1,"MMM") but not the other way around for these text values.

Right now I'm using an If function nested 12 deep, which just looks ugly.