MONTH


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.






 
Created with Zapof