The YEAR function

Returns the year of a date.

In German Excel: JAHR

How to write it

=YEAR(serial_number)

serial_number: A date.

💡 MONTH and DAY work the same way.

Try it

In which year was order 1001 placed?

E2

A

B

C

D

E

1

Order

Customer

Ordered

Delivered

Year

2

1001

Kim

3/3/25

3/7/25

3

1002

Ali

3/10/25

3/11/25

4

1003

Kim

4/2/25

4/9/25

5

1004

Jo

4/15/25

4/18/25

6

1005

Ali

5/20/25

5/23/25

=YEAR(date).