The YEAR function returns the year from a date as an integer.
|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.
|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|