How to use EOMONTH in Excel
The last day of a month, some months away.
Syntax
start_dateA datemonths0 for this month, 1 for next monthExample
Here’s EOMONTH on a small table of orders. The highlighted cells are the ones the formula reads.
=TEXT(EOMONTH(DATE(2026,11,2),0),"m/d/yyyy")Edit this formula live Change the ranges and watch the answer update. Free, no sign-up.
Common mistakes with EOMONTH
The result is a date number
Format the cell as a date, or wrap in TEXT, to read it.
Months can be negative
EOMONTH(A2,-1) gives the last day of last month; EOMONTH(A2,-1)+1 is the first of this month.
What the error messages mean
Type these slips into Gridwise and this is the feedback you get:
Leaving off the closing bracket
=TEXT(EOMONTH(DATE(2026,11,2),0),"m/d/yyyy"
Parentheses don’t match. You have 3 opening and 2 closing parentheses. Every ( needs a ).
Questions
What does the EOMONTH function do in Excel?
The last day of a month, some months away. The syntax is EOMONTH(start_date, months).
Why is my EOMONTH formula giving the wrong answer?
The result is a date number: Format the cell as a date, or wrap in TEXT, to read it. Months can be negative: EOMONTH(A2,-1) gives the last day of last month; EOMONTH(A2,-1)+1 is the first of this month.
Does EOMONTH work in Google Sheets?
Most Excel functions, including the core ones on this page, work the same way in Google Sheets. A few newer functions arrived in Sheets later or behave slightly differently, so test it on your own data.