YEAR function
Conversion — a serial number to a year.
Date and time
Where can you use it?
Planning and operations teams. Use this group to work with dates and times in calendars, delivery schedules, shifts and period reporting.
Scenario in the workbook
Extract the calendar year. Apply a separate rule if your fiscal year starts in a different month.
A worked example from the workbook
| Row | A |
|---|---|
| 6 | Excel date serial |
| 7 | 46023 |
| 8 | 46081 |
| 9 | 45351 |
Record 1
=YEAR(A7)Expected result2026
See the inputs and instructions for all 3 examplesSyntax
YEAR(serial_number)
Copyable formulas
English Excel · en-US
=YEAR(DATE(2026,11,30))Turkish Excel · tr-TR
=YIL(TARİH(2026;11;30))Expected result
2026
Worked examples
Extract the calendar year. Apply a separate rule if your fiscal year starts in a different month.
Open the English sheet. Inputs begin at A6. F7:F9 show the live results and G7:G9 show the original results for comparison.
| Row | A |
|---|---|
| 6 | Excel date serial |
| 7 | 46023 |
| 8 | 46081 |
| 9 | 45351 |
| Case | Formula | Expected result |
|---|---|---|
| Record 1 | =YEAR(A7) |
2026 |
| Record 2 | =YEAR(A8) |
2026 |
| Record 3 | =YEAR(A9) |
2024 |