The YEAR Function in EXCEL is a DATE function in Excel that is used to calculate the year value from a given date. This function takes a date as an argument and returns a four-digit numeric value as an integer value representing the year of the given date.
The syntax for The YEAR Function: YEAR (serial_number)