EOMONTH + TODAY Function in Excel: Syntax, Examples and Free Practice
EOMONTH + TODAY is an Excel Date & Time function. Finds the last day of the current month, automatically staying current as the month changes.
EOMONTH + TODAY syntax
Arguments
0: 0 = this month, 1 = next month, -1 = last month
When to use EOMONTH + TODAY
Automatically calculating the deadline for this month's report as the last day of the month.
Practice EOMONTH + TODAY online, free
Open the live Excel-style spreadsheet and try EOMONTH + TODAY yourself. No Excel install or sign-up needed to start.
Practice EOMONTH + TODAY now →More Date & Time functions
Frequently asked questions
What does the EOMONTH + TODAY function do in Excel?
Finds the last day of the current month, automatically staying current as the month changes.
What is the syntax of EOMONTH + TODAY in Excel?
The syntax is =EOMONTH(TODAY(), 0). 0: 0 = this month, 1 = next month, -1 = last month.
Where can I practice EOMONTH + TODAY online for free?
Open the free live spreadsheet on Cellgrids and try EOMONTH + TODAY yourself. No Excel install is needed and you can start without signing up.
All Excel formulas · Cheat sheet · Excel exercises · Date and Time functions · Excel case studies · Excel tutorials · Excel shortcuts