Court Deadlines & Limitation Periods: Business-Day Counting, Holidays & Docket Calendars

What you'll build

What you will be able to do

Each lab ends with a concrete result that you build yourself and the checker confirms, cell by cell.

• 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.
• 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.
• Look up the extra days for each service method in a rules table, build raw and final deadlines that add those days and roll forward from closed days, and work backwards to the latest day a reply can still be posted.
• Start each limitation clock on the later of incident and discovery, add the period for the claim type in years with EDATE, cap it with a long-stop counted from the incident and show how many days are left.
• Count the days of each pause, total the paused days per claim with SUMPRODUCT, push the expiry back by that total and clip a pause that started before the clock was running.
• 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.
• Build a personal docket for the lawyer selected in J1: the open deadlines in the next 30 days, the next open deadline, a list of the five earliest open deadlines with SMALL and FILTER, and the matter behind each date.
• 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.