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.


YEAR(DATE(2013, 1, 1))YEAR(DATE(2013; 1; 1))

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