Answers for "how to make a month value into a numeric value in excel"

excel convert month name to number

FORMAT
=MONTH(DATEVALUE(CELL&"1"))

USSAGE
B1=MONTH(DATEVALUE(A1&"1"))
- where A1 = "Jan", "January" or any month name

Posted by: Guest on July-01-2021

Code answers related to "how to make a month value into a numeric value in excel"