Home/Formulas/Date/EOMONTH
Datemedium

EOMONTH()

Returns the last day of the month a specified number of months before or after a date.

Syntax
fx
=EOMONTH(start_date, months)
Arguments
ArgumentDescription
start_dateThe starting date.
monthsThe number of months to advance (negative for prior months, 0 for the current month).
Example
fx
=EOMONTH("2026-01-15", 0)

Paste this into Google Sheets to run it. The live playground on this site covers 24 of the 61 functions, and EOMONTH isn't one of them yet.

Related formulas
EDATE()
Returns the date a specified number of months before or after another date.
DATE()
Constructs a date value from year, month, and day numbers.
DAY()
Returns the day of the month component of a date as a number from 1 to 31.
Used by
DATE()
Constructs a date value from year, month, and day numbers.
EDATE()
Returns the date a specified number of months before or after another date.
More Date formulas →Keyboard shortcuts for Sheets →