EDATE
Moves a date forward or back by whole months.
How it’s written
EDATE(date, months)Example
| A | |
|---|---|
| 1 | Date |
| 2 | 46,096 |
=EDATE(A2,1)Result: 46,127
Returns April 15, 2026. Format the cell as a date to see it.
Try it yourself
Open a live sheet with this example, and type the formula yourself. It takes a moment to load.
Worth knowing
Better than adding 30 days, because months differ in length.
Practice it properly
Calculating with dates gives you real tasks, with your formulas tested on data you haven’t seen.