Quick Answer & Formula
Excel
Sheets
Beginner
=EOMONTH(start_date, months) To find the last calendar day of the current month, use =EOMONTH(TODAY(), 0). To find the last day of the next month, use =EOMONTH(TODAY(), 1). To find the first day of next month, use =EOMONTH(TODAY(), 0) + 1.
How to Find the End of the Month in Excel & Google Sheets (EOMONTH)
Accounting closing schedules, monthly invoicing deadlines, and financial statements require calculating the final day of monthly and quarterly accounting periods.
1. Core Formulas Reference Table
| Objective | Formula | Output (for August 2026) |
|---|---|---|
| End of Current Month | =EOMONTH(TODAY(), 0) | 08/31/2026 |
| End of Next Month | =EOMONTH(TODAY(), 1) | 09/30/2026 |
| End of Prior Month | =EOMONTH(TODAY(), -1) | 07/31/2026 |
| First Day of Next Month | =EOMONTH(TODAY(), 0) + 1 | 09/01/2026 |
| First Day of Current Month | =EOMONTH(TODAY(), -1) + 1 | 08/01/2026 |
| Total Days in Month | =DAY(EOMONTH(TODAY(), 0)) | 31 |
?
Frequently Asked Questions
How do I get the number of total days in the current month?
Use =DAY(EOMONTH(TODAY(), 0)). For February 2026, it returns 28. For August 2026, it returns 31.