EOMONTH in Zoho Sheet: Syntax, Real Examples and Troubleshooting
Find the final calendar day of a target month for closing dates, payments and reports.
Verification status: Official documentation referenced; example outcomes independently reasoned or arithmetically checked where stated. Not executed in Zoho Sheet. How formula examples are checked
Zoho Sheet EOMONTH: get the last day of any month
Quick answer: =EOMONTH(DATE(2024;1;15);1) yields a serial date whose expected calendar display is 2024-02-29. EOMONTH calculates the last calendar date of the month reached by moving the specified number of months from a starting date. Unlike EDATE, it ignores the starting day when deciding the returned day of the month.
Official syntax and arguments
=EOMONTH(start_date; months)
| Argument | Required? | Definition |
|---|---|---|
start_date |
Yes | Calendar date to begin from. Prefer a true date cell (B2) or DATE(2024;1;15) rather than ambiguous text. |
months |
Yes | Integer month shift to target month: 0=current month, 1=next month, -1=prior month. |
The output is a date serial; apply a date cell format. Zoho documents positive and negative months, but does not explicitly state how noninteger offsets, invalid historical date ranges or time components are handled. Use integers and flag other cases for a real Zoho execution check.
Reproducible practice data
Make a new sheet called BillingDates and enter the following values. Column B must contain actual date cells, not ISO strings imported as text; select the column and apply a date format. Enter the dates manually or construct them with DATE(year;month;day) if CSV import treats YYYY-MM-DD as text. Column C must be a signed integer; D is also a date. The accompanying CSV supplies source text only and cannot itself certify inferred spreadsheet data types.
| Sheet row | A: Case | B: Start date | C: Month offset | D: Deadline |
|---|---|---|---|---|
| 2 | INV-101 | 2024-01-31 | +1 | 2024-03-10 |
| 3 | INV-102 | 2024-02-29 | +12 | 2025-02-28 |
| 4 | INV-103 | 2026-03-15 | -2 | 2026-04-01 |
| 5 | INV-104 | 2026-10-11 | +3 | 2026-10-26 |
| 6 | INV-105 | 2025-12-31 | +2 | 2026-01-15 |
| 7 | INV-106 | 2026-05-30 | -1 | 2026-06-03 |
| 8 | INV-107 | 2026-07-04 | +0 | 2026-07-20 |
| 9 | INV-108 | 2026-08-31 | +6 | 2026-09-02 |
Use the semicolon function separator used in Zoho’s official web documentation. Cell formats may show dates differently; the expected outputs below are in ISO YYYY-MM-DD only to remove locale ambiguity. Dates and output values were calculated independently, not obtained by running formulas in Zoho.
Follow the steps and check expected answers
- In F1, enter
Month closing date, and format F2:F9 as dates. - Put
=EOMONTH(B2;C2)in F2. For B2 = 2024-01-31, C2 = +1, February 2024’s final day is 2024-02-29. - Fill through row 9. Independently calculated month-closing dates are:
| Row | Case | Start date | Offset | Expected month end |
|---|---|---|---|---|
| 2 | INV-101 | 2024-01-31 | +1 | 2024-02-29 |
| 3 | INV-102 | 2024-02-29 | +12 | 2025-02-28 |
| 4 | INV-103 | 2026-03-15 | -2 | 2026-01-31 |
| 5 | INV-104 | 2026-10-11 | +3 | 2027-01-31 |
| 6 | INV-105 | 2025-12-31 | +2 | 2026-02-28 |
| 7 | INV-106 | 2026-05-30 | -1 | 2026-04-30 |
| 8 | INV-107 | 2026-07-04 | +0 | 2026-07-31 |
| 9 | INV-108 | 2026-08-31 | +6 | 2027-02-28 |
- To get October 2026’s final date, enter
=EOMONTH(DATE(2026;10;11);0)→ 2026-10-31. - For the preceding month:
=EOMONTH(DATE(2026;10;11);-1)→ 2026-09-30. - For leap-year comparison,
=EOMONTH(DATE(2024;2;1);0)→ 2024-02-29 while=EOMONTH(DATE(2025;2;1);0)→ 2025-02-28.
The results above are date values, not strings; regional formatting may display them as 31/10/2026, 10/31/2026, or a serial integer.
Advanced application: month-end financial reporting
For each invoice date in B2:B9, create a consistent calendar-month reporting key with =EOMONTH(B2;0). For example both 2026-03-01 and 2026-03-31 become 2026-03-31, making grouping by reporting period easier. The key remains a date rather than text such as "Mar 2026".
To get the first calendar date of the following month, use =EOMONTH(B2;0)+1. For a separate scratch example with B11 = 2026-10-11, expected result 2026-11-01; put =EOMONTH(B11;0)+1 in an empty cell. To test whether a shipment date in D11 is in the same month as a start date in B11, use:
=IF(EOMONTH(D11;0)=EOMONTH(B11;0);"Same month";"Different month")
For scratch inputs B11 = 2026-10-11 and D11 = 2026-10-26, expected result is Same month. These are independent logical/date calculations, not native Zoho-tested outputs.
Troubleshooting and boundary conditions
| Observation | Explanation | Recommended action |
|---|---|---|
| Result displays a serial number | Numeric cell format shows internal date value | Apply date format, don’t convert the serial to typed text. |
| Returns last day instead of same day next month | EOMONTH is designed to return month end | Use EDATE for same-day monthly anniversaries. |
| February shifts between 28 and 29 | Leap-year/calendar rules | Check target year with YEAR, not only source year. |
#VALUE! |
Invalid date/text or invalid argument | Use genuine date cells and numeric integer offsets. |
| Typed date changes day and month | Date input locale interpreted differently | Enter DATE(year;month;day) and verify Locale settings. |
#NAME! |
Typo or unexpected argument separator | Check formula helper; Zoho web docs use semicolons. |
| Fractional month or very early date | Reference leaves boundary handling unclear | Record NATIVE_TEST_REQUIRED instead of relying on Excel. |
How EOMONTH differs from EDATE and Excel
| Input | Formula | Expected displayed date |
|---|---|---|
| Jan 15, 2024 | =EDATE(DATE(2024;1;15);1) |
Feb 15, 2024 |
| Jan 15, 2024 | =EOMONTH(DATE(2024;1;15);1) |
Feb 29, 2024 |
| Mar 31, 2026 | =EOMONTH(DATE(2026;3;31);-1) |
Feb 28, 2026 |
Microsoft Excel EOMONTH explicitly truncates noninteger month arguments and documents #NUM! on certain invalid dates. Zoho’s current EOMONTH does not specify those precise details. Do not copy Excel-specific boundary guarantees into a Zoho guide without a native test.
Availability, Excel and Google Sheets considerations
Zoho’s current public help lists this function, but does not provide its original release date or a comprehensive feature matrix for web, mobile, and older clients. As of 2026-10-11, the Zoho September 2026 update says the Windows/macOS beta desktop apps use Excel-native formula syntax by default for offline files. Consequently, check the editor’s suggestions for argument separator and import interpretation before copying formulas verbatim. A comma is commonly used in Microsoft Excel examples; this page uses Zoho help’s semicolons. Formula names matching other apps do not establish feature-identical versions.
For date display and parsing, see Zoho Spreadsheet locale and calculation settings: File → Spreadsheet Settings → Locale offers date format, time zone and separators. Use DATE(2024;1;31) rather than ambiguous text such as "1/31/24" in portable examples. Some serial-number displays or historical-date conventions may differ between applications; this is not a verified cross-application cell-level comparison.
Official reference and verification
Verification status: Official documentation checked; example outcomes were independently reasoned or arithmetically checked where applicable. Not executed in Zoho Sheet.
- No genuine Zoho Sheet screenshots are included; this guide does not use mock application images.