Date & Time
Modern
YEAR
Extracts the year from a date.
Available in All versions
Syntax
YEAR(serial_number)What it returns
The 4-digit year, as a number.
Arguments
| Argument | Required | Description |
|---|---|---|
serial_number |
Yes | The date to read the year from. |
Example
| A | |
|---|---|
| 1 | Date |
| 2 | 06/11/2026 |
Result
2026
YEAR reads the year out of a date (2026).
=YEAR(A2)Important to know
Returns a 4-digit year.
Input must be a valid Excel date.