Practice challenge
Flag overdue orders
#5
3 attempts remaining
BeginnerOrdersTarget D2
An operations sheet tracks whether orders shipped after their due date.
Write a formula for D2 that returns "Overdue" when the ship date is after the due date, otherwise "On time".
Flag overdue orders
Swipe horizontally to view the full table.
| A | B | C | D | |
|---|---|---|---|---|
| # | Order | Due date | Ship date | Status |
| 2 | A-104 | 2026-07-02 | 2026-07-03 | blank |
| 3 | A-105 | 2026-07-04 | 2026-07-04 | blank |
| 4 | A-106 | 2026-07-05 | 2026-07-01 | blank |
| 5 | A-107 | 2026-07-06 | 2026-07-08 | blank |