The EOMONTH function
The last day of a month, shifted by the number of months you want: the "30 days end of month" due date in one formula.
Syntax
=EOMONTH(start_date, months)
In a French Excel: =FIN.MOIS(date_départ; mois).
Arguments
- start_date: the reference date.
- months: 0 for the same month, 1 for the next, -1 for the previous.
An example
=EOMONTH(A2+30,0)
The "30 days end of month" due date of an invoice dated in A2.
Pitfalls
- The result shows as a number without a date format.
- The first day of the month:
=EOMONTH(A2,-1)+1.
Going further
Frequently asked questions
- How do I group dates by month?
=EOMONTH(A2,0)gives the same value to every date of a month: a good grouping key.