The Next-Court-Day Rule: When a Deadline Lands on a Weekend or Holiday
This lesson is part of the course
In this lesson
You find the weekday of each raw deadline, test whether the court is closed that day, roll closed-day deadlines forward to the next court day with the WORKDAY(date − 1, 1) trick and highlight every deadline that moved.
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