EOMONTH Function in Google Sheets

Returns the end of the month that is a specified number of months before or after a given date.

EOMONTH Function

The EOMONTH function returns the end of the month that is a specified number of months before or after a given date.

Syntax

EOMONTH(start_date, months)
  • start_date: The starting date.
  • months: The number of months to add (positive) or subtract (negative).

Examples

  1. Basic Example

Find the end of the month 6 months after August 14, 2024:

=EOMONTH(DATE(2024, 8, 14), 6)
  1. Subtracting Months

Find the end of the month 3 months before August 14, 2024:

=EOMONTH(DATE(2024, 8, 14), -3)

Notes

  • This function is useful for determining the end date of a month given a starting date and a number of months.
  • EDATE: Returns a date that is a specified number of months before or after a given date.