Statute of Limitations Deadline

Excel Formulas › Legal & Billing

All versionsEDATE

A statute of limitations bars a claim filed after a deadline measured from the accrual date. EDATE (for month/year periods) or simple date math computes the bar date — and a warning window before it.

Quick formula: bar date N years after accrual:
=EDATE(accrual_date, years*12)
EDATE adds the limitation period in months. A 2-year SOL from the accrual date is EDATE(date, 24).

Functions used (tap for the full reference guide):

EDATEWORKDAY

The example

2-year SOL from an injury date.

AB
1ItemValue
2Accrual2026-06-19
3Bar date (2 yr)→ 2028-06-19

The formula

The formula:

=EDATE(accrual_date, years*12) // accrual plus the limitation period

How it works

How it works:

  1. EDATE(accrual, months) adds the limitation period — use years×12 for a year-based SOL.
  2. Days remaining = bar_date - TODAY() — the live countdown to the deadline.
  3. Add a warning window: flag matters within, say, 90 days of the bar date.
  4. Tolling, discovery rules, and weekends/holidays can shift the real date — treat this as a calendaring aid, not legal advice.

This is a docketing aid, not the deadline of record. Real SOL dates bend around discovery rules, tolling, minority/disability, and whether the last day falls on a weekend or court holiday (often rolled to the next business day — use WORKDAY). The spreadsheet should surface deadlines early and loudly; a calendaring professional and the governing statute set the actual date. Missing a SOL is malpractice — build in margin.

Try it: interactive demo

Live demo

Accrual date and SOL years.

Bar date ·

Variations

Days remaining

Live countdown:

=bar_date - TODAY()

Warning flag

Within 90 days:

=IF(bar_date-TODAY()<=90, "DEADLINE SOON", "")

Roll off weekends

Next business day:

=WORKDAY(bar_date-1, 1, holidays)

Pitfalls & errors

EDATE for months/years. It preserves the day-of-month across the period.

Build in margin. Flag early — never calendar to the literal last day.

Not legal advice. Tolling and discovery rules can change the date — verify with the statute.

Practice workbook

📊
Download the free Statute of Limitations Deadline practice workbook
A statute-of-limitations sheet with the days-remaining, warning, and weekend-roll variants, plus 4 challenges with answers. No sign-up required.

Frequently asked questions

How do I calculate a statute of limitations date in Excel?
Add the period with EDATE: =EDATE(accrual_date, years*12). A 2-year SOL from the accrual date is EDATE(date, 24).
How do I count down to the deadline?
Subtract today: =bar_date - TODAY(), and flag matters within 90 days with an IF.
What if the deadline lands on a weekend?
Roll to the next business day with =WORKDAY(bar_date-1, 1, holidays). Always verify the real date against the statute.

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

Related formulas: Court deadline day count · Add months · Add business days

Function references: EDATEWORKDAY