Exercises / Dates and deadlines · 4 of 10

When does each contract end?

EDATE(start, months) moves a date by whole months, keeping the day of the month. Adding 30 per month drifts; EDATE does not.

Your taskIn D2, use EDATE to return the end date of each contract: the start date in B2 plus the number of months in C2. It will be copied down to D7.
Pro

Unlock this exercise and every module after the basics.

Pro opens every exercise in every module, your review schedule, and the final test for the course certificate.

See plansI already have Pro
RowABCD
1ClientStartMonthsEnds
2Acme15 Jan 202612
3Bolt1 Feb 20266
4Corvo31 Mar 20263
5Delta10 May 202624
6Ember20 Aug 202612
7Flux5 Oct 20261