Table of Contents
Summary
The Excel YEAR function returns the year, a number between 1900 and 9999. The YEAR function is an Excel date and time function.
Function
=YEAR(serial_number)
Arguments (inputs)
serial_number = a number representing a date in Microsoft Excel
Return value
The YEAR function returns the year, a number between 1900 and 9999.
Example
In the example above the YEAR function returns the year for the date in cell C5.
=YEAR(C5)
The result returned is 2018.
