Planning & productivity
Deadline status board
Sort a dated task table by days remaining relative to your reference date.
A clear answer. Here’s how.
Subtracts strict Gregorian YYYY-MM-DD dates in UTC calendar days and sorts ascending by days remaining. Labels negative differences overdue, zero due today and positive upcoming. Up to 1,000 tasks, with dates in years 0001–9999. Reference date is explicit; no automatic reminders, business-day or public-holiday adjustment.
See a worked example
Worked example
A fixed demonstration, separate from the values you enter above.
- Reference date
- 2026-10-17
- Project CSV
Task,DueDate Example report,2026-10-20 Example booking,2026-10-16
Example result
| Task | Due date | Calendar days remaining | Status |
|---|---|---|---|
| Example booking | 2026-10-16 | -1 | Overdue |
| Example report | 2026-10-20 | 3 | Upcoming |
Dates are strict YYYY-MM-DD and differences use UTC calendar days relative to your supplied reference date. Does not send reminders or remove holidays/weekends.