EDATE Function in Google Sheets

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

EDATE Function

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

Syntax

EDATE(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 date 6 months after August 14, 2024:

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

Find the date 3 months before August 14, 2024:

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

Notes

  • This function is useful for calculating future or past dates based on months.
  • EOMONTH: Returns the end of the month for a specified number of months before or after a given date.