YEAR pulls the year out of a date: given 2026-11-16 it returns 2026. It reads an Excel date serial (or a DATE() result) and ignores the month and day. It is the building block for grouping by year, fiscal-year labels and age calculations.
Returns a number 1900β9999. The year of the given date.
One part of a date, isolated. Click any row to load it.
| Expression | Result | Why |
|---|---|---|
| =YEAR(C2) | 2026 | Year of 2026-11-16 |
| =YEAR(C3) | 2026 | Year of 2026-01-01 |
| =YEAR(C5) | 2025 | Year of 2025-12-31 |
| =YEAR(C8) | 2024 | Leap-year date 2024-02-29 |
| =YEAR(DATE(2026,11,16)) | 2026 | From a constructed date |
| =YEAR(C2)&"-"&MONTH(C2) | 2026-11 | Year-month label |
Edit the table or type any formula β the engine evaluates instantly. Load a preset to extract the year from a date.
8 failure patterns mined from actual user reports on Reddit, Stack Overflow and Super User β each with the authentic symptom, root cause, a fix, and a runnable formula. Not textbook theory.
YEAR is a core date function present in every Excel version and platform.
| Platform | Support | Notes | Gotcha |
|---|
YEAR is one piece. The full course walks the toolkit end to end with live, measured examples.