3

My list has a field for report month. The month is selected from a list and is displayed in text format (Jan, Feb, etc.) For sorting puposes, I want to add a calculated column that will assign the month's numeric value (01, 02, etc.). Any help writing the formula would be extremely, greatly appreciated. Thank you in advance.

Improve this question

1 Answer 1

Reset to default
3

You will need to convert the Text date into Date and then extract the month.

Try this:

=MONTH(DATEVALUE(CONCATENATE("1-",MonthColumnName)))

1 being the first day of the month (and a dash) is added to convert text into date

enter image description here

More details on DateValue here and Month here

Improve this answer
1
  • Although my own situation uses fully spelled-out month names, and thus requires a different syntax within the DATEVALUE function, this answer still gave me enough to figure out what I needed.
    – Dan Henderson
    Commented Jul 23, 2018 at 15:37

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.