Excel YEAR Function

HomeExcel FunctionsExcel YEAR Function (Example + Sample File)


The Excel YEAR Function is listed under Microsoft Excel's Date Functions category. It returns the year number from a valid date. As you know, in Excel a date is a combination of day, month, and year, and YEAR function gets the year from the date and ignores the rest of the part.

How to use it

To learn how to use the YEAR function in Excel, you need to understand its syntax and arguments:




  • date: A date from which you want to get the year.


  • You can only extract the year number from a date which is after 01-01-1900.
  • It always returns year in four digits.


To master the YEAR function we need to try it out in an example, so make sure to check out the below one:

In the below example, we have used the year function to get the year number from the dates.

You can use this function where you have dates in your data and you only need the year number.

And in the below example, we have used today function to get year number from the current date.

It will always update the year whenever you recalculate your worksheet.

Related functions

This tutorial is the part of our Excel Functions with Examples (Function Guide) and below are some of the related functions:

About the Author

Puneet Gogia

Puneet is using Excel since his college days. He helped thousands of people to understand the power of the spreadsheets and learn Microsoft Excel. You can find him online, tweeting about Excel, on a running track, or sometimes hiking up a mountain.