Beginner

Get the year from a date

Pull just the year out of a full date, ready to group or filter by it.

The formula

=YEAR(A2)

How it works

A
1Date
206/11/2026
Result
2026

YEAR reads the year part out of the date (2026).

Functions used