YEAR Function
Returns the year from a date.
Category
Date & Time
Available in
All versions, Microsoft 365
Returns
A four-digit year
Overview
YEAR returns the year of a date as a four-digit number from 1900 to 9999.
Use it to group by year, to compare a date with the current year, or with DATE to build dates in the same year.
Syntax
=YEAR(serial_number) Explain
Arguments
| Argument | Required? | What it does |
|---|---|---|
| serial_number | Yes | The date to read. |
Examples
Example 1 — Year of each invoice
Northstar's invoices span three years.
B2fx=YEAR(A2)
| A | B | |
|---|---|---|
| 1 | Invoice date | Year |
| 2 | 11/2/2025 | 2025 |
| 3 | 3/15/2026 | 2026 |
| 4 | 1/9/2027 | 2027 |
=YEAR(A2) Explain
Example 2 — Is this date in the current year?
Compare with the year of TODAY.
=IF(YEAR(A2)=YEAR(TODAY()), "This year", "Other year") Explain
Common mistakes
- YEAR returns 1900. The cell is empty or holds a small number rather than a date.
Notes

Author
Kyle Stott
Certified Microsoft Excel Expert
Kyle has worked professionally with Microsoft Excel for over a decade and has consulted on and taught Excel best practices to over 400 companies across 30+ countries.