Loading exercise…
Loading exercise…
Exercises are built for a keyboard. Read the task here, then open this page on a laptop to solve it.
EDATE. EDATE(start_date, months) returns the same day of the month a number of months later (or earlier, with a negative number). Adding days can’t do this, because months have different lengths. If the day doesn’t exist, such as 31 Feb, EDATE uses the month’s last day.
=EDATE(D2,12) the renewal date one year after a contract signed in D2
Every Brightline sales rep has a first review six months after their hire date. HR wants the review dates for the most recent hires.
In C2:C7, return the date exactly six months after each hire date in column B.
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Rep | Hire date | Review date | |||||
| 2 | Ana Lopez | 2025-04-29 | ||||||
| 3 | Lena Fischer | 2024-11-25 | ||||||
| 4 | Jade Turner | 2024-11-16 | ||||||
| 5 | Omar Haddad | 2024-05-02 | ||||||
| 6 | Sofia Lind | 2023-01-27 | ||||||
| 7 | Tom Becker | 2022-07-14 | ||||||
| 8 | ||||||||
| 9 | ||||||||
| 10 |
=IF(B2>=1.5,SUM(C2:C9),0)Language
Full plan
Excel ✓ · SQL and Power BI also included
Cancel anytime · 14-day full refund · Secure payment by Stripe