The Excel YEAR function returns the year component of a date as a 4-digit number. You can use the YEAR function to extract a year number from a date into a cell or to extract and feed a year value into another formula, like the DATE function.
Syntax
The syntax for the YEAR function in Microsoft Excel is:
=YEAR( date_value )
Parameters or Arguments
date_value
A valid date to return the year value.
Year Function Examples
Column B of the following spreadsheet shows the Excel Year function, used to extract the year from three different dates.
Formulas:
Results:
