Days Overdue Calculator
An invoice, a library book, and a project milestone all share the same awkward question once the deadline passes: exactly how late is it? Guessing invites arguments, so this days overdue calculator does the one honest subtraction, current date minus due date, and gives you a day count you can put in an email, an aging report, or a late fee note.
It counts calendar days, weekends included, and it is strict about the edge case most tools fudge: on the due date itself, and on any date before it, the item is not overdue yet.
Calendar days only. If your contract counts business days, or starts the clock after a grace period, adjust the due date you enter to match those terms.
Quick Answer
Key takeaways
- The due date is day zero. Lateness starts the day after, which is why equal dates return not overdue.
- The count is calendar days. Weekends and holidays are included unless your contract says business days.
- The second date does not have to be today. Enter a payment or return date and the tool measures how late that event actually was.
- A day count alone does not set a late fee. The fee comes from the amount owed plus the terms you agreed in advance.
- Quick Answer
- How to use the days overdue calculator
- The formula behind the day count
- Worked example: an invoice checked 16 days late
- Aging buckets: what the day count should trigger
- Days overdue, days outstanding, and days between pay periods are not the same number
- What competing calculators miss
- Frequently Asked Questions
- Add This Calculator to Your Website
- References
How to use the days overdue calculator
Enter the due date first: the deadline on the invoice, the return date stamped in the book, or the milestone date in the project plan. Then enter the date you are checking against. That is usually today, but it does not have to be. If a client finally paid on a known date, enter that payment date instead and the result documents exactly how late the payment landed, which is the number you need for a late fee note or a dispute file.
Press Calculate. You get the day count, the aging bucket that count falls into, and a short note on the follow-up step that bucket normally calls for. If the second date is the due date or earlier, the tool says not overdue rather than showing zero or a negative number. That behavior is deliberate: a negative lateness figure in a report confuses everyone who reads it later.
The formula behind the day count
The formula is a single subtraction, and the only subtlety is how the endpoints are treated.
Whole days matter. The tool converts both dates to timestamps, takes the difference, and divides by the milliseconds in a day, rounding down. Time of day never enters the result, so checking at 9 in the morning or 9 at night gives the same count. The due date itself is day zero: a payment due on the 20th and made on the 21st is 1 day late, not 2. Most disagreements about lateness are really disagreements about that convention, so state it plainly in any reminder you send: due September 20, checked October 6, 16 days past due.
For a portfolio view rather than a single item, accountants average this idea across every unpaid invoice. That average is the subject of the days outstanding calculator in this batch, which works from receivables and credit sales instead of two dates.
Worked example: an invoice checked 16 days late
The calculator is pre-filled with this case, and the figures below are exactly what it returns.
Due date: September 20, 2026. The invoice terms made payment due on this date, so this is day zero.
Check date: October 6, 2026. September has 30 days, so September 21 to September 30 accounts for 10 days, and October 1 to October 6 adds 6 more.
Result: 16 days overdue. That places the invoice in the 1 to 30 day aging bucket, the stage where a friendly reminder normally resolves it.
Run the same dates through the tool and you will see 16 day(s), the 1 to 30 day bucket, and the early-stage verdict. Change only the check date to September 20 and the result flips to not overdue, which is the cleanest way to see the day-zero rule working.
Aging buckets: what the day count should trigger
A raw day count becomes useful when it maps to an action. Accounts receivable teams have used the same buckets for decades, and this calculator labels your result with the bucket it lands in.
| Days overdue | Bucket | Typical next step |
|---|---|---|
| 0 | Current | Not due yet, or due today. No action. |
| 1 to 30 | Early | Friendly reminder with the invoice attached again. |
| 31 to 60 | Escalating | Written follow-up naming the day count; ask for a firm payment date. |
| 61 to 90 | Serious | Phone call plus written notice; check contract terms on pausing work. |
| Over 90 | Oldest | Formal notice; apply only the fees your contract actually allows. |
The mirror image of this table sits on the buying side of a business. The days payable calculator measures how long a company takes to pay its own suppliers, and a firm that collects in 20 days but pays in 45 is financing itself out of its suppliers, a gap worth knowing about before you extend it credit.
Days overdue, days outstanding, and days between pay periods are not the same number
Three similar phrases cause real confusion in small business bookkeeping. Days overdue, this page, is a single item against its own deadline: one invoice, one due date, one count. Days outstanding is an average across a whole receivables ledger, built from totals rather than dates on a single bill, and the average settlement period calculator covers that same average from the settlement angle. Days between pay periods is unrelated to lateness entirely: the days between pay periods calculator measures the gap between two paydays for payroll planning. Picking the wrong one produces a number that looks precise and means nothing, so match the tool to the question before you quote the result.
One more distinction matters for employees and borrowers: overdue is not the same as expired. An overdue obligation is still expected to be completed or paid, often with a fee attached. An expired one, like a lapsed permit, has ended and usually has to be renewed or reissued rather than simply completed late.
What competing calculators miss
The tools ranking for this keyword split into two camps, and both leave work on the table.
Miss 1: Excel tutorials instead of a tool. Much of the ranking content explains TODAY() and DATEDIF formulas for spreadsheets. That helps if you maintain a ledger, but someone holding one invoice needs two date fields and an answer, not a formula lesson. This page gives the answer first and explains the arithmetic after.
Miss 2: a count with no bucket. The dedicated days past due tools that do exist stop at the number. None of the ones reviewed label the result with its aging bucket or the follow-up step that bucket calls for, even though the bucket is what a credit controller actually acts on. The verdict line under the result here does that mapping.
Miss 3: fuzzy edge cases. Several tools return 0 or a negative number when the check date falls before the due date, leaving the reader to interpret it. This calculator states not overdue in words, because that is the answer a person needs in a reminder email.
An honest limit: this tool knows nothing about grace periods, business-day contracts, or partial payments. If an invoice was partly paid, the remaining balance is what is overdue, and the day count applies to that balance from the original due date unless your agreement says otherwise.
Frequently Asked Questions
One full calendar day after the due date. If something was due on September 20 and you check on September 21, it is 1 day overdue. On the due date itself the count is still zero and this calculator reports it as not overdue, matching the live tool logic: only a current date strictly after the due date produces a count.
Yes. It counts calendar days, so Saturdays, Sundays, and public holidays all count. Some contracts and court rules count business days instead. If your agreement uses business days, treat this calendar count as the starting point and check the contract wording before acting on it.
You get the not overdue message. The tool compares the two dates and only reports a number when the current date is later than the due date. Equal dates mean the deadline has not been missed yet.
They sort unpaid invoices by days overdue and work the oldest first. Standard accounts receivable aging buckets group balances as current, 1 to 30, 31 to 60, 61 to 90, and over 90 days past due, and each bucket usually triggers a firmer follow-up step, from a polite reminder to a formal notice.
No. Days overdue measures one specific item against its own due date. Days outstanding, often called days sales outstanding, is a company-wide average of how long receivables stay unpaid. This page covers the single-item count; the portfolio average is a different calculation.
Yes. Enter the date the item was actually paid, returned, or completed as the current date. The result then tells you how late that payment or return was, which is how you document lateness for a late fee or a dispute.
No. It gives you the day count only. A late fee also needs the amount owed and the fee terms in your contract, such as a flat fee or a monthly percentage. Get the day count here first, then apply your agreed terms to it.
Usually because of the due date itself. The due date is day zero, not day one. Count forward from the day after the due date and the numbers will match. Time of day never matters here because the tool compares whole dates.
Add This Calculator to Your Website
References
- US Department of the Treasury, Bureau of the Fiscal Service, Invoice Processing Platform prompt pay guidance on payment due dates and late interest penalties under the Prompt Payment Act. Treasury: IPP Prompt Pay Guidance. Accessed October 2026.
- Invoice Generator, days past due calculator and accounts receivable aging bucket definitions (current, 1 to 30, 31 to 60, 61 to 90, 90 plus). Invoice Generator: Days Past Due Calculator. Accessed October 2026.
- Federal Acquisition Regulation clause 52.232-27 on prompt payment and late payment interest penalties for construction contracts. Acquisition.gov: FAR 52.232-27 Prompt Payment. Accessed October 2026.
- Consumer Financial Protection Bureau, credit card late fee and penalty fee rules under Regulation Z, for how lateness charges are capped on consumer cards. CFPB: Regulation Z Section 1026.52, Limitations on Fees. Accessed October 2026.
- 31 U.S.C. Section 3902, Prompt Payment Act interest penalties: the penalty period begins the day after the required payment date and ends on the date payment is made. GovInfo: 31 U.S.C. Section 3902, Interest Penalties. Accessed October 2026.