Go Back

Excel YEAR Function – PENDING

Want to learn more about how to returns an integer representing the year of a supplied date using excel spreadsheet?? This post will give you an overview of how to returns an integer representing the year of a supplied date in excel.

Syntax(Generic Formula)


  • Serial_number [Required]: It is the date of the year that we want to find. By using DATE function, date enter.

How the YEAR function Works

The YEAR function in Excel is a date & time function that is used for returns the year number from a given date. The function will return a four-digit year integer that is a year corresponding to a mentioned date.

Figure 1: Example of returns the year corresponding to a date

To find the year corresponding to a date the YEAR you can use the function. In the example selected cell shown, the formula in D6 is:


The Excel YEAR function returns the year component of a date as a 4-digit number. In Excel YEAR function you can extract a year number from a date into a cell.

More about Excel YEAR Function

  • Excel can store in a serial number form.
  • if the reference date is valid then It will only return year number
  • You can extract only year number from given date which must be after 01-01-1900.
  • It will return year in four digits.

Did this post not answer your question? Get a solution from connecting with the expert.

Another blog reader asked this question today on Excelchat:
Here are some problems that our users have asked and received explanations on

I have a long list of donors who have given last year and this year. Some gave last year, but not this year. I need to sort my spreadsheet so that it tells me who gave last year but did not give this year.
Solved by K. L. in 19 mins
I'd like to calculate year over year percentage change.
Solved by F. F. in 12 mins
I have a huge list of donors from last year and this year. I need to separate them based on who gave last year, that has not given this year.
Solved by C. A. in 23 mins

Leave a Comment