Home › Functions › Date & Time › YEAR
fx
YEAR
Date & Time  ·  Since: Excel 2003  ·  9 languages

Returns the year corresponding to a date. The year is returned as an integer in the range 1900-9999.

🌐 Translations

English YEAR
Deutsch JAHR
Français ANNEE
Español AÑO
Italiano ANNO
Português ANO
Nederlands JAAR
Polski ROK
Русский ГОД

📦 Availability

Excel versionAvailable
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.

▶ Examples

=YEAR(A3)
=YEAR(A4)

Related functions

Copied to clipboard