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.
Syntax
=YEAR (date)
Arguments
| Arguments | Description | Remarks |
| date | A valid Excel date | Mandatory |
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.
Availability
Since 2007 for Windows.
Since 2011 for Mac.