ExcelFlux

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

RowA
6Excel date serial
746023
846081
945351
Record 1
=YEAR(A7)

Expected result2026

See the inputs and instructions for all 3 examples

Syntax

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
Microsoft Excel reference