get month from the date in excel code example

Example: 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)