ExcelHeroThe DAYS function
Counts the days between two dates.
In German Excel: TAGE
How to write it
=DAYS(end_date, start_date)- end_date
- The later date (comes first).
- start_date
- The earlier date.
💡 Same as end − start, but reads clearly.
Try it
How many days between ordering and delivery of order 1003? Use DAYS.
A
B
C
D
E
1
Order
Customer
Ordered
Delivered
Days
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
=DAYS(end, start) – the end comes first.