Get year from date

★ 15 minutes read

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.

Example 1

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.

Our customers love us!
“The expert was absolutely amazing and stuck with me the whole way through. They were polite, patient, seemed to want to genuinely help me and provided a solution that I would never have managed otherwise. I could not be more thankful for their support and solution. Thank you!” - - Chris T, in California

Leave a Comment