Functions
EDATE
Date serial N months before or after a start date
Try it
When to use it
When should I use EDATE instead of adding days to a date?
Use EDATE when you need a date exactly N calendar months before or after a start date, preserving the day-of-month as closely as possible.
Used in
Syntax
EDATE(start,months)Examples
=EDATE(DATE(1969,7,20),1) // => 25435
=EDATE(40909,-2) // => 40848
=EDATE(DATE(2023,1,15),6) // => 45122