Article updated on March 17, 2018

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



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


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.