The Docket List: Days Left, Traffic-Light Status and the Next 14 Days
This lesson is part of the course
In this lesson
You turn a docket into days left from the as-of date, give every entry a Done / Overdue / Red / Amber / Green status, count the open deadlines due in the next 14 days and colour the urgent rows.
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
- Calendar Days vs Court Days: WORKDAY and a Holiday Table Locked
- The Next-Court-Day Rule: When a Deadline Lands on a Weekend or Holiday Locked
- Extra Days by Service Method: Lookup Rules and the Latest Posting Date Locked
- Limitation Periods in Months and Years: EDATE, Discovery Rule and Long-Stop Locked
- Tolling: Adding Paused Periods Back to the Expiry Date Locked
- The Docket List: Days Left, Traffic-Light Status and the Next 14 Days Locked
- A Personal Docket per Lawyer: COUNTIFS, MINIFS, SMALL and FILTER Locked
- Capstone: A Month Calendar View of the Docket Locked