Answers for "get month name from number 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

excel get month from date

# A2 contains '15/09/2021'

# To get month from a date as a STRING
=TEXT(A2, "mm") 			' 9		(string)
=TEXT(A2, "mm") 			' 09	(string)
=TEXT(A2, "mmm") 			' sept
=TEXT(A2, "mmmm") 			' september

# To get month from a date as a NUMBER
=MONTH(DATE(2021,9,15)) 	' 9		(number)
=MONTH(A2) 					' 9		(number)