YEAR
Returns the year of a date.
How it’s written
YEAR(date)Example
| A | |
|---|---|
| 1 | Date |
| 2 | 46,096 |
=YEAR(A2)Result: 2,026
The date is in 2026.
Try it yourself
Open a live sheet with this example, and type the formula yourself. It takes a moment to load.
Worth knowing
Useful for grouping by year in SUMIFS or a helper column.
Practice it properly
Taking dates apart gives you real tasks, with your formulas tested on data you haven’t seen.