Returns the month of a given date.
Syntax:
MONTH(date)
returns the month of date as a number, where January is 1 and December is 12. date may be text or a date-time serial number.
Example:
MONTH("2021-12-04")
returns 12.
MONTH(A1)
where cell A1 contains the date 1 Nov 2021 as a date-time serial number, returns 11.