Google Sheets function
EOMONTH function in Google Sheets
EOMONTH in Google Sheets returns the final day of a month a specified number of months before or after a starting date. Use zero for the current month, positive numbers for later months, and negative numbers for earlier months when building reporting or billing dates.
Source: Google Docs Editors HelpLast verified Nov 5, 2026
Syntax
=EOMONTH(start_date, months)Arguments
| Argument | Required | What it means |
|---|---|---|
start_date | Yes | The date used as the starting month. |
months | Yes | The number of months before or after the starting month. |
Examples
Find the next month end
| A | B | |
|---|---|---|
| 1 | Report | Start date |
| 2 | Monthly close | 1/15/2024 |
=EOMONTH(B2,1)Result: 45351
One month after January is February, whose final day in 2024 is February 29. The result is that date's serial value.
Common mistakes
Using 1 when the end of the starting month is required.
Use 0 to return the final day of the month containing start_date.
Treating the result as ordinary text.
Format the result cell as a date to display the returned date value.