Forum Discussion
formulas
I need help writing a formula that takes a month and converts it to an integer between 1 and 12.
1 Reply
Hi Morgan,
Could be
=MONTH(DATEVALUE(A1&"1"))
if in the cell text as one of Jan, Feb,... or January, February, etc.
I need help writing a formula that takes a month and converts it to an integer between 1 and 12.
Hi Morgan,
Could be
=MONTH(DATEVALUE(A1&"1"))
if in the cell text as one of Jan, Feb,... or January, February, etc.
