Google Sheets Function

EOMONTH

Return the last day of the month a given number of months before or after a date.

Generate a formula with AI Same function in Excel

This function works the same in Google Sheets as it does in Excel — same syntax and arguments.

Syntax

EOMONTH(start_date, months)

EOMONTH finds month-end dates — essential for billing cycles, financial periods, and due dates. Pass 0 for the current month's end, positive numbers for future months, negative for past ones.

Arguments

start_daterequiredThe starting date.
monthsrequiredMonths before (negative) or after (positive) the start date.

Examples

=EOMONTH(A2, 0)

Result: 2026-06-30

Returns the end of A2's month.

=EOMONTH(A2, 1)+1

Result: 2026-07-01

Gets the first day of next month.

FAQ

How do I get the first day of a month?

Use =EOMONTH(date, -1)+1 — the day after the previous month's end.

Related functions

TODAY DATEDIF