EDATE
Returns the serial number of the date that is the indicated number of months before or after the start date.
Date & TimeDates & Time Calculations
What it does
Adds or subtracts months from a date.
Syntax
EDATE(start_date, months)
Arguments
start_date(date) — The starting date.months(number) — Number of months to add (positive) or subtract (negative).
Examples
Add Months
Add 3 months to Jan 15.
FORMULA
=EDATE(A2, 3)
RESULT
2023-04-15
SAMPLE DATA
| A | |
|---|---|
| 1 | Date |
| 2 | 2023-01-15 |