In this tutorial, you will learn how to get a year from date. This is possible by using Excel YEAR function. Above all, you will need to format the cells which contain dates as a date type. Also, it is possible to use text cells in this function, but this can cause errors due to users’ settings, so it is recommended to format all cells as dates. Furthermore, the cells where the formula is applied must be formatted as a number or general, because the function returns a year.
Get year from the date
The YEAR function enables a user to get a year from date. The only parameter of this function is a date cell reference.
In the following example we will see how you can use YEAR function to get a year from date:
Figure 1. Get a year from the date
As you can see in the picture we have dates in column B (“Date”) for which we want to return a year in column C (“Year”). For the date in cell B3 24-Feb-2018, we will get the year 2018 in the cell C3, as this is the year of the selected date.