ExcelHeroThe DATEDIF function
Counts whole days, months or years between two dates.
How to write it
=DATEDIF(start_date, end_date, unit)- start_date
- The earlier date.
- end_date
- The later date.
- unit
- "d", "m" or "y".
💡 Use "y" to work out age or years of service.
Try it
How many whole months are between the first and the last order?
A
B
C
D
1
Order
Customer
Ordered
Delivered
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
7
8
Months
=DATEDIF(start, end, "m").