ExcelHeroThe EDATE function
Adds a number of months to a date.
In German Excel: EDATUM
How to write it
=EDATE(start_date, months)- start_date
- The date.
- months
- Months to add. Negative goes back.
💡 Ideal for renewals, warranties and due dates.
Try it
The warranty lasts 12 months from delivery. When does it end for order 1001?
A
B
C
D
E
1
Order
Customer
Ordered
Delivered
Warranty
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
=EDATE(date, months).