Excel function · Dates
EOMONTH
Returns the last day of a month, a number of months away.
What it does
EOMONTH moves a date forward or back by whole months and returns the last day of that month. It suits due dates such as "end of next month" and month-end reports, and it knows how long each month is.
Syntax
=EOMONTH(start_date, months)Arguments in square brackets are optional, and … means you can add more of the same. In this Excel language, arguments are separated by ,
Arguments
- start_date
- The date to start from.
- months
- How many months to move: 0 for the end of the same month, 1 for next month, -1 for last month.
Example
Invoices are due at the end of the month after they are issued. When is an invoice from 20 January 2026 due?
| A | B | |
|---|---|---|
| 1 | Invoice date | Due date |
| 2 | 2026-01-20 | 2026-02-28 |
The formula in B2:
=EOMONTH(A2,1)Result: 2026-02-28
One month after January is February, and February 2026 has 28 days, so the due date is 2026-02-28.
Common mistakes
- Seeing a number such as 46081 instead of a date. Give the cell a date format.
- Using 0 when you mean next month. 0 is the end of the current month.
In other Excel languages
Excel translates function names, and in some languages the argument separator too. Type the name your Excel shows.
| Excel language | Function name | Separator |
|---|---|---|
| English | EOMONTH | , |
| Deutsch | MONATSENDE | ; |
| Français | FIN.MOIS | ; |
| Español (España) | FIN.MES | ; |
| Español (México) | FIN.MES | , |
| 日本語 | EOMONTH | , |
| 한국어 | EOMONTH | , |
| 繁體中文 | EOMONTH | , |
| ไทย | EOMONTH | , |
| ខ្មែរ | EOMONTH | , |
| Tiếng Việt | EOMONTH | ; |