Court Deadline by Counting Days

All versionsWORKDAY

Court rules set deadlines as a number of days from a trigger — sometimes calendar days, sometimes court (business) days. WORKDAY counts business days and skips holidays; plain addition counts calendar days.

Quick formula: a deadline N business days out:

=WORKDAY(trigger_date, days, holidays)

WORKDAY adds business days, skipping weekends and a holiday list. Use trigger+days for calendar days.

Functions used (tap for the full reference guide):

WORKDAY WORKDAY.INTL

The example

21 court days to respond.

	A	B
1	Item	Value
2	Trigger	2026-06-19
3	+21 court days	→ deadline

The formula

The formula:

=WORKDAY(trigger_date, days, holiday_range) // business days, skipping holidays

How it works

How it works:

WORKDAY(trigger, days, holidays) counts forward in business days, skipping weekends and the holiday list.
For calendar days, just add: trigger_date + days.
Use WORKDAY.INTL if the court week isn’t Mon–Fri or you need custom non-working days.
If the computed date is itself a holiday/weekend, rules usually roll to the next business day.

Calendar days vs court days is the classic trap. “Within 30 days” (calendar) and “within 30 court days” (business) can differ by two full weeks. Read the rule, then pick trigger + days for calendar or WORKDAY for court days, and maintain an accurate holiday list for the specific court. As always, this is a calendaring aid — confirm against the governing rules.

Try it: interactive demo

Live demo

Trigger date and number of days.

Trigger

Days

Court days · Calendar

Variations

Calendar days

Simple addition:

=trigger_date + days

Custom work week

Non-standard court days:

=WORKDAY.INTL(trigger, days, "0000011", holidays)

Roll a calendar deadline

If it lands on a weekend:

=WORKDAY(trigger+days-1, 1, holidays)

Pitfalls & errors

Calendar vs court days. Read the rule — they can differ by weeks.

Holiday list. WORKDAY only skips holidays you supply — keep it current per court.

Not legal advice. Confirm against the governing rules — this is a calendaring aid.

Practice workbook

📊

Download the free Court Deadline by Counting Days practice workbook

A court-deadline sheet with the calendar-days, custom-week, and roll variants, plus 4 challenges with answers. No sign-up required.

Frequently asked questions

How do I count court deadline days in Excel?

For business days use =WORKDAY(trigger_date, days, holidays); for calendar days just add: =trigger_date + days.

What's the difference between calendar and court days?

Calendar days count every day; court days count only business days (skipping weekends and holidays), which can differ by weeks.

How do I handle a non-standard court week?

Use WORKDAY.INTL with a weekend mask, e.g. =WORKDAY.INTL(trigger, days, "0000011", holidays).

Stop fighting formulas. Learn them in a day.

This recipe is one of hundreds of real-world formulas we teach. Our Excel Formulas & Functions class covers lookups, logic, text, and dynamic arrays hands-on — live in Dallas–Fort Worth, Houston, Austin, Oklahoma City, Denver, or online.

See the Formulas & Functions Class

Function references: WORKDAY WORKDAY.INTL