What is the syntax of YEAR Function in Excel?

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 4-digit number


=YEAR (date)


The YEAR function extracts the year from a given date as a 4-digit number.

=YEAR("23-Aug-2012") // returns 2012 
=YEAR("11-May-2019") // returns 2019