Excel Study · Module 7: Dates & times
Class 59EDATE: add months
Intermediate2:02 videoFree
=EDATE(B2,C2) gives the date C2 months after the start date in B2 — a renewal, a due date, a contract end.
Try this AI prompt
Works in ChatGPT, Gemini, Copilot or Claude.
In Excel, B2 has a subscription start date. Write a formula for D5 that gives the renewal date 6 months after the start date.
The answer that works
✓ checked in Excel=EDATE(B2,6)
AI can get Excel wrong. Paste its answer into Excel and test it before you trust it.