YEAR Function in Excel – Get year from date in Excel

YEAR function in Excel returns the four digit year when date is given as an input. Excel YEAR Function takes date input in the form of

  • Reference to cells containing dates
  • Date Serial numbers
  • Date values returned from other Excel formulas
  • Date as a text input

Syntax for YEAR Function in Excel

YEAR (date)

 date – A date from which year is extracted

Example of YEAR Function in Excel

Formula:

year function in excel 1

  • Row number 2 and 3 are Reference to cells containing dates
  • Row number 4 is date serial number
  • Row number 5, the date is given as a text input
  • Row number 6,the date values are returned from DATE Formula
Result:

year function in excel 2

previous-small YEAR Function in Excel                                                                                                         next_small YEAR Function in Excel