In the example, the formula is:
B4 contains a date value for January 5, 2016.
The YEAR function returns the number 2016 representing the year of the date.
Get year from date
If you need to extract the year from a date, you can use the YEAR function. In the generic form of the formula above, the date must be in a form that Excel recognizes as a valid date.
