What is EOMONTH?
Returns the last day of a month, a specified number of months before or after a date. Perfect for month-end reporting and deadlines.
Syntax
=EOMONTH(start_date, months)
Example
Formula: =EOMONTH(A1, 0)
Result: Month end date
How It Works
Returns the last day of the month. months=0 for same month, 1 for next month, -1 for previous month. Handles varying month lengths automatically.