Returns the year corresponding to a date. The year is returned as an integer in the range 1900-9999.
🌐 Translations
EnglishYEAR
DeutschJAHR
FrançaisANNEE
EspañolAÑO
ItalianoANNO
PortuguêsANO
NederlandsJAAR
PolskiROK
РусскийГОД
📦 Availability
Excel version
Available
Excel 2007
✓
Excel 2013
✓
Excel 2019
✓
Excel 2021
✓
Microsoft 365
✓
Translate a formula with this function
fx EN
fx DE
⌨ Syntax
YEAR(serial_number)
Arguments
serial_number(required)
— The date of the year you want to find. Dates should be entered by using the DATE function, or as results of other formulas or functions. For example, use DATE(2025,5,23) for the 23rd day of May, 2025. Problems can occur if dates are entered as text.