The YEAR function returns the year from a date as an integer.

Syntax

=YEAR(serial_number)

Arguments

Argument Description
serial_number The date from which to extract the year

Note: The serial_number argument is the date that you want to return the year from. This can be supplied to the YEAR function as either:

  • A reference to a cell containing a date, or
  • A date returned from another function or formula

Warning: If you attempt to input the date argument as text, there is a chance that Excel may misinterpret this, depending on the date system, or date interpretation settings on your computer.

Examples

  A B C D
1 Date Formula Result Notes
2 1/1/2013 =YEAR(A2) 2013 Year of the date in cell A2
3 Monday, June 01, 1976  =YEAR(A3) 1976 Year of the date in cell A3
4 30-Jul-2013 =YEAR(A5) 2013 Year of the date in cell A5

Common Function Error(s)

Problem What went wrong
Result looks like a date, e.g. “01/01/1900”, instead of an integer Likely due to cell formatting, i.e. the function has returned the correct value, but the cell is formatted as a ‘date’, instead of an integer