What is the syntax of YEAR Function in Excel?

Data Science, AI and ML
,
#1

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

Syntax

=YEAR (date)

Example:

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