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
0
Would love your thoughts, please comment.x
()
x