IF with Dates: Overdue Invoices & Weekend Deliveries
This lesson is part of the course
In this lesson
You label Brightline's receivables as Paid, Overdue or Open, count the days overdue, spot weekend deliveries with WEEKDAY and move them to the next Monday.
Buy the course once for $9.99 to unlock every lesson and lab, the final exam and the certificate – lifetime access, no subscription.
Lessons in this course
- Simple IF: Pass/Fail and Over/Under Budget Locked
- IF with AND, OR & NOT: Eligibility Rules Locked
- Nested IF vs IFS: Grade Bands & Commission Tiers Locked
- SWITCH, CHOOSE & XLOOKUP: Replacing Nested IFs Locked
- IF with Text: SEARCH, LEFT, EXACT & LEN Locked
- IF with Dates: Overdue Invoices & Weekend Deliveries Locked
- Error Handling: IFERROR vs IFNA, ISBLANK & ISNUMBER Locked
- Logic-Driven Status Dashboard: COUNTIFS, SUMIFS vs IF Arrays Locked