
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.
Purpose
Get the year from a date
Return value
Year as a 4-digit number
Syntax
=YEAR (date)
Arguments
- date – A valid Excel date.
- The YEAR function extracts the year from a given date as a 4-digit number. For example:
=year("23-Aug-2012") // returns 2012
=year("11-May-2019") // returns 2019
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:
=date(year(A1),1,1) // first of same year