Practice challenge
Calculate days until due
#27
3 attempts remaining
BeginnerDatesTarget D2
A project tracker compares a fixed current date to task due dates.
Write a formula for D2 that returns days between the due date and the current date in C2.
Calculate days until due
Swipe horizontally to view the full table.
| A | B | C | D | |
|---|---|---|---|---|
| # | Task | Due date | Current date | Days left |
| 2 | Draft | 2026-07-15 | 2026-07-09 | blank |
| 3 | Review | 2026-07-12 | 2026-07-09 | blank |
| 4 | Launch | 2026-07-20 | 2026-07-09 | blank |