The YEAR function returns the year of a date.
Formula:
=YEAR(serial_number)
Explanations:
Serial_number is required, the date you need to find the year.
Cautions:
Dates are stored as sequential serial numbers and January 1, 1900 is serial number 1.
How to Use YEAR Function