Skip to content
Google Sheets

EOMONTH function in Google Sheets

Returns a date representing the last day of a month which falls a specified number of months before or after another date.

=EOMONTH(start_date, months)

EOMONTH syntax and parameters

Two arguments, two required.

  • start_datenumberRequired

    The date from which to calculate the result.

  • monthsnumberRequired

    The number of months before (negative) or after (positive) start_date to consider. The last calendar day of the calculated month is returned.

EOMONTH examples

Formulas you'll actually reuse.

  1. The last day of the invoice's month — month-end close:

    =EOMONTH(B2, 0)

    Result2026-08-31

  2. The first day of the same month — end of last month, plus one:

    =EOMONTH(B2, -1) + 1

    Result2026-08-01

EOMONTH in Excel

Same name — your formula ports as-is.

Try EOMONTH in the playground

Edit the example — nothing to install.

Preloaded with the EOMONTH formula from Example 1 — change anything and watch it respond.

Loading the editor…

Related functions

More ways Google Sheets gets this done.