ExcelHeroThe EOMONTH function
Returns the last day of a month.
In German Excel: MONATSENDE
How to write it
=EOMONTH(start_date, months)- start_date
- The date.
- months
- 0 for the same month, 1 for next month.
💡 EOMONTH(date,-1)+1 is the first day of the month.
Try it
Invoices are due at the end of the order month. When is order 1002 due?
A
B
C
D
E
1
Order
Customer
Ordered
Delivered
Due
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
=EOMONTH(date, 0) is the last day of the same month.