EDATE

The EDATE function returns a date a specified number of months before or after a start date.

Syntax

=EDATE(start_date, months)

Parameters

• start_date: The start date
• months: The number of months before (negative) or after (positive) start_date

Examples

=EDATE("2024-01-15", 1) // Returns February 15, 2024
=EDATE("2024-01-15", -1) // Returns December 15, 2023
=EDATE("2024-01-31", 1) // Returns February 29, 2024 (handles month end dates)