Excel Functions

Excel YEAR Function

Pinterest LinkedIn Tumblr

The YEAR function returns the year component of a date as a 4-digit number.

Purpose of Excel YEAR Function

You can use the YEAR function to extract a year number from a date into a cell or to extract and feed a year value into another formula, like the DATE function.

Return value

YEAR as 4-digit number.


=YEAR (date)


dateA valid Excel dateMandatory

Usage notes

  • This function extracts the year from a given date as a 4-digit number.
  • Dates are serial numbers in Excel, and begin on January 1, 1900.
  • Dates before 1900 are not supported.
  • To display date values in a human-readable date format, apply a the number format of your choice. A valid Excel date.


Since 2007 for Windows.
Since 2011 for Mac.

Related Posts

Write A Comment