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
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)
=YEAR(“8/6/1986”) will give 1986