Level 2Dates, Part 2Practice, 2 min
EDATE: when does the contract renew?
The task
Each contract renews a number of months after it starts. In D2, use
EDATE to find the renewal date from the start date in B2 and the term in C2.The data
The starting sheet. Cells outlined in green are where your formulas go.
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Customer | Start | Term (months) | Renews |
| 2 | Bean There Coffee | Aug 14, 2026 | 6 | |
| 3 | Sir Loin Steakhouse | Sep 1, 2026 | 12 |