Capstone: A Month Calendar View of the Docket
This lesson is part of the course
In this lesson
You build a six-week Monday-to-Sunday calendar grid from one date, highlight every day that carries a deadline with a conditional formatting rule and count the deadlines of the month with COUNTIFS and EOMONTH.
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