Excel YEAR Function
The Excel YEAR function returns the year component of a date as a 4-digit number. 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.
- date - A valid Excel date.
The YEAR function extracts the year from a given date as a 4-digit number. For example:
You can use the YEAR function to extract a month number from a date into a cell, or to feed a month number into another function like the DATE function:
See below for more examples of formulas that use the DATE function.
Note: 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 the number format of your choice.
- Date must be a valid Excel date.
- YEAR will return a #VALUE error on text values.