Excel YEAR function

Function              YEAR

Description        Excel YEAR function returns the year of a date value. The year is given as an integer, ranging from 1900 to 9999.

Syntax  YEAR (serial_number)

serial_number It is value in excel date format

Example:

Click Here to see posts related to YEAR