Excel Function : YEAR
Date and time
Converts a serial number to a year
Microsoft Excel Reference Page
Syntax and Description of the YEAR Excel Function
The YEAR function in Excel returns the year component of a date as a number between 1900 and 9999. The syntax of the YEAR function is as follows: YEAR(date) where date is a valid date.
About YEAR Excel Function
The YEAR function returns a four-digit year (a number from 1900 to 9999) given a date value.