How to use Excel YEAR Function

how to use excel year function

Quick Intro

Use Excel YEAR Function to get the year from a date. In simple words, it will return year value from a date. For example, from 12-Aug-2016 it will return 2016.

Syntax

YEAR(serial_number)

serial_number A serial number which represents the date from which you want to get the year value.

More Information on Excel YEAR Function

  • Excel store dates as serial numbers.
  • It will only return year number if reference date is valid.
  • You can only extract year number from a date which is after 01-01-1900.
  • It always returns year in four digits.

Examples

In the below example, I have used year function to get year number from the dates. You can use this function where you have dates in your data & you only need year number.

You can also use TEXT Function to get the year from a date.

use excel year function with to get year number

In the below example, I have used today function to get year number from the current date. It will always update the year whenever you recalculate your worksheet.

use excel year function with today function

Sample File

download sample file to learn more about this tips

What’s Next?

To learn more about Excel YEAR Function you can check Microsoft’s Help Section. And, if you have a unique idea to use it, I would love to hear from you.There is also you have

There are also you have MONTH | DAY functions which are highly useful. Apart from this, I have a list of excel functions and some real life formulas examples.