Exceljet

Quick, clean, and to the point

Excel YEAR Function

Excel YEAR function
Summary 

The Excel YEAR function returns the year component of a date as a 4-digit number. You can use the YEAR function to extract a year number from a date into a cell or to extract and feed a year value into another formula, like the DATE function.

Purpose 
Get the year from a date
Return value 
Year as 4-digit number
Syntax 
=YEAR (date)
Arguments 
  • date - A valid Excel date.
Usage notes 

The YEAR function extracts the year from a given date as a 4-digit number. For example:

=YEAR("23-Aug-2012") // returns 2012
=YEAR("11-May-2019") // returns 2019

You can use the YEAR function to extract a month number from a date into a cell, or to feed a month number into another function like the DATE function:

=DATE(YEAR(A1),1,1) // first of same year

See below for more examples of formulas that use the DATE function.

Note: dates are serial numbers in Excel, and begin on January 1, 1900. Dates before 1900 are not supported. To display date values in a human-readable date format, apply a the number format of your choice.

Notes

  • Date must be a valid Excel date.
  • YEAR will return a #VALUE error on text values.

Excel Formula Training

Formulas are the key to getting things done in Excel. In this accelerated training, you'll learn how to use formulas to manipulate text, work with dates and times, lookup values with VLOOKUP and INDEX & MATCH, count and sum with criteria, dynamically rank values, and create dynamic ranges. You'll also learn how to troubleshoot, trace errors, and fix problems. Instant access. See details here.