Excel Function : YEAR
Category
Date and time
Description
Converts a serial number to a year
Microsoft Excel Reference Page
https://support.office.com/en-us/article/YEAR-function-c64f017a-1354-490d-981f-578e8ec8d3b9
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.