Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.
Last reviewed:
YEAR
YEAR takes a date serial number or date text and returns the year component as a whole number. It is ideal for grouping records by year, filtering annual data, or building dynamic date calculations that depend on the current year.
Excel
=YEAR(DATE(2024,6,15))Google Sheets
=YEAR(DATE(2024,6,15))✓
Verified example
Computed by a real spreadsheet engine on the sample data below.
| DateValue | YearResult |
| 2023-01-15 | |
| 2024-06-30 | |
| 2022-12-01 | |
| 2025-03-20 |
=YEAR(DATE(2024,6,15))→2024
Try it with your data
Edit the grid or formula, then run it through a real spreadsheet engine — no signup.
Sample data — click any cell to edit
Runs server-side · free · no signup
How it works
- 1Ensure your dates are stored as real Excel date values (not text) in column A.
- 2In cell B2 type =YEAR(A2) to extract the year from the date in A2.
- 3Copy the formula down and use the year values to group or filter your data.