The YEAR function converts a date to a number representing the year in the date. The number is between 1900 and 9999.

Excel function syntax

YEAR(serial_number)

Arguments

serial_number - The date you want to extract the year out of.

Comments

Excel uses whole numbers as dates. January, 1 , 1900 is 1 and January, 1, 2000 is 36526. There are 36525 days between those two dates.