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)