MONTH function

MONTH(Date) MONTH(Date)

Date

Number or { Number }

The date to be converted, as a sequential serial number.

Returns

Number or { Number }

The month of the date (1 through 12).

Converts a date to a number representing the month of the date.

Example

MONTH(DATE(2013, 1, 5))MONTH(DATE(2013; 1; 5))

Returns 1, the month of the given date, January 5, 2013.