YEAR
Converts a serial number to a year.
Date & TimeDates & Time CalculationsMost Used
What it does
Returns the year from a date.
Syntax
YEAR(serial_number)
Arguments
serial_number(date) — Date to extract from.
Examples
Extract year
Get the year from A2.
FORMULA
=YEAR(A2)
RESULT
2026
SAMPLE DATA
| A | |
|---|---|
| 1 | Date |
| 2 | 2026-03-15 |
| 3 | 2025-12-31 |