Calculate days late, due date, or actual return date from any two values to find the missing date or number of days quickly and easily.
Related Calculators
- Prorate Bill Calculator
- Splitting Bills Based On Income Calculator
- Lease Penalty Calculator
- Average Daily Balance Calculator
- All Personal Finance Calculators
Days Late Formula
The days late calculation is the difference between the actual return date and the due date, measured in calendar days. The calculator can also work backward to find the due date or actual return date when you enter the other two values.
Days\ Late = ceil((Actual\ Return\ Date - Due\ Date) / (1000*60*60*24))
Actual\ Return\ Date = Due\ Date + Days\ Late
Due\ Date = Actual\ Return\ Date - Days\ Late
- Days Late is the number of calendar days after the due date.
- Due Date is the date the item, task, payment, or assignment was expected.
- Actual Return Date is the date it was actually returned, completed, or received.
- ceil means the result is rounded up to the next whole day when needed.
- 1000 × 60 × 60 × 24 converts milliseconds into days.
If you enter the due date and actual return date, the calculator finds the number of days late. If you enter the due date and days late, it finds the actual return date. If you enter the actual return date and days late, it finds the original due date.
How to Interpret Days Late Results
| Result | Meaning | Example |
|---|---|---|
| Negative number | The return date is before the due date. | Due May 10, returned May 8 = -2 days late |
| 0 | The return date is the same as the due date. | Due May 10, returned May 10 = 0 days late |
| Positive number | The return date is after the due date. | Due May 10, returned May 13 = 3 days late |
Common Calendar Day Counts
| Due Date | Actual Return Date | Days Late |
|---|---|---|
| 2026-01-01 | 2026-01-02 | 1 |
| 2026-03-15 | 2026-03-22 | 7 |
| 2026-06-30 | 2026-07-05 | 5 |
| 2026-12-28 | 2027-01-03 | 6 |
Example
Example 1: Find days late
Suppose the due date is 2026-04-10 and the actual return date is 2026-04-14.
Days\ Late = 2026\text{-}04\text{-}14 - 2026\text{-}04\text{-}10 = 4The result is 4 days late.
Example 2: Find the actual return date
Suppose the due date is 2026-09-20 and the item is 6 days late.
Actual\ Return\ Date = 2026\text{-}09\text{-}20 + 6\ days = 2026\text{-}09\text{-}26The actual return date is 2026-09-26.
FAQ
Does the calculator count the due date as a late day?
No. If something is due on May 10 and returned on May 10, the result is 0 days late. The count starts after the due date has passed.
Can days late be negative?
Yes. A negative result means the actual return date is before the due date. For example, if something is due on May 10 and returned on May 8, the result is -2.
Does this count calendar days or business days?
This calculator counts calendar days. Weekends and holidays are included because the calculation is based only on the difference between two dates.