All functions / Date & Time
YEAR
The year of a date.
Syntax
=YEAR(serial_number)
Arguments
serial_number: A date (or a cell containing one).
Example
=YEAR(A2) → 2025
All functions / Date & Time
The year of a date.
=YEAR(serial_number)
serial_number: A date (or a cell containing one).=YEAR(A2) → 2025