Answers for "excel convert month number to short name"

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 "excel convert month number to short name"