Quick Answer
YEAR Function
YEAR returns the year component of a date.
✓ Excel✓ Google SheetsExcel All versions
Syntax
YEAR
(serial_number)
Parameters
| Parameter | Description | Required |
|---|---|---|
| serial_number | The date from which to extract the year. | Required |
Basic Example
Extract year from date
=YEAR("1/15/2026")Result2026
Returns the year from the date "1/15/2026".
Advanced Examples
Example 1: Group data by year
Data analysisExtract years for grouping in pivot tables
=YEAR(A1)Result: 2026
Converts dates to years for easier grouping.
How YEAR Works
YEAR extracts the year from a date serial number. Dates in Excel are stored as serial numbers where January 1, 1900 is day 1.
1
Select output cell
Choose where the year should appear.
2
Enter formula
Type =YEAR(date).
3
Press Enter
The result shows the year.
Important Notes & Limitations
YEAR only returns the year.
For month or day, use MONTH or DAY functions.
Common Errors & Fixes
#VALUE!Non-date argumentFix: Ensure the argument is a valid date.
Download Practice File
YEAR
yearPractice YEAR with Real Data
Download a sample CSV file with pre-populated data and practice exercises for the YEAR function. Works in both Excel and Google Sheets.
Works in Google SheetsCompatible with ExcelIncludes exercises
File format: CSV (comma-separated values) - opens in Excel, Google Sheets, and all spreadsheet apps
Related Tutorials
Frequently Asked Questions
What year does Excel start from?
Excel uses the 1900 date system, starting from January 1, 1900.
Can YEAR handle dates before 1900?
No, Excel cannot handle dates before January 1, 1900.