The MONTH function

Returns the month of a date as a number from 1 to 12.

In German Excel: MONAT

How to write it

=MONTH(serial_number)

serial_number: A date.

💡 Use it with SUMPRODUCT or FILTER to total by month.

Try it

In which month (as a number) was order 1003 placed?

E4

A

B

C

D

E

1

Order

Customer

Ordered

Delivered

Month

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

=MONTH(date).