YEAR

Returns only the year of a given data

Syntax of Excel Year formula:
=YEAR(serial_number)

In words:
=Just give the year(of this data)

Example of Excel Year Formula

=YEAR(“8/6/1986”) will give 1986