Month to Number

Angela L

I have a month field that I would like to switch to a number for sorting.

I have tried a bunch of different calculations to try and get the Month field to turn into a number but haven't been successful.

Kelly P.

@Angela L

The basic idea of the formula that Itai provided is the one to use. However, since the month is just a text string, you don't need the month function (which works on dates, not text). Try this format; keep going until all of the months are present:

=IF(Month@row = "January", 1, IF(Month@row = "February", 2))

Hope this helps!

Itai Perez

Hey,

Try this formula: =IF(MONTH([month]@row) = "January" , "1", IF(MONTH([month]@row) = "February", 2....))

Keep writing this formula for all of the months.

Angela L

I have tried this formula and it doesn't work, I get UNPARSEABLE error. The month is being populated via a drop down box, I am not sure if that is making a difference. The information is being populated via a form.

Kelly P.

@Angela L

The basic idea of the formula that Itai provided is the one to use. However, since the month is just a text string, you don't need the month function (which works on dates, not text). Try this format; keep going until all of the months are present:

=IF(Month@row = "January", 1, IF(Month@row = "February", 2))

Hope this helps!