Calendar Days vs Court Days: WORKDAY and a Holiday Table
This lesson is part of the course
In this lesson
You count filing deadlines in calendar days and in court days with WORKDAY and a court-holiday table, pick the right method per matter with IF, and handle a tribunal that also sits on Saturdays with WORKDAY.INTL.
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