YEAR function

YEAR(Date) YEAR(Date)

Date

Number or { Number }

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

Returns

Number or { Number }

The year of the date.

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

Example

YEAR(DATE(2033, 1, 1))YEAR(DATE(2033; 1; 1))

Returns 2033, the year of the given date, January 1, 2033.