Calculator

Enter up to 10 jobs. Gaps are completed → sent, sent → due, due → paid, and completed → paid.

Negative Gap 1 or Gap 2 means a date is out of order and shows a warning. Negative Gap 3 shows 0 days late on screen, but the raw negative value stays in averages. Averages count only rows with both dates.

Your numbers

• Average Completed → Sent gap:
• Average Sent → Due gap:
• Average Due → Paid raw gap:
• Average days late shown:
• Average total cycle:
• Collection time handed away/year:

Formula notes

• ASSUMPTION: Date gaps are calendar-day differences; negative Gap 1 or Gap 2 shows a warning instead of being hidden.
• ASSUMPTION: Negative Gap 3 displays as 0 days late, while the raw value stays in averages.
• ASSUMPTION: Averages count only rows with both dates and show the number of jobs counted.