You're an AR analyst building a conditional-formatting rule that highlights invoices that are past due and still open. Columns A–C contain InvoiceID, DueDate (yyyy-mm-dd), and Status (Open/Paid).
Treat today's date as 2026-05-04 (the reference date used for grading; in production this would be TODAY()).
An invoice is overdue when both:
- The DueDate is before 2026-05-04, and
- The Status is Open (paid invoices are no longer collectible regardless of date).
Your task:
- In column D (Overdue), write a single formula that returns
"Yes" for overdue invoices and "No" otherwise.
- The formula must drag-fill from D2 → D13.
Graded cells: D2 (INV-001 — Apr 1, Open → Yes), D5 (INV-004 — May 10, Open → No, future date), D10 (INV-009 — Apr 25, Paid → No, paid).
Open this problem on a desktop to attempt it.