A to-do list that knows what's late: task, category, priority, due date and a ✓ when done; status (Done, Overdue, Today, Soon, Open), days left and a progress bar are calculated. Pro adds a Focus sheet listing what's overdue and due this week, a Board with counts per category, person and priority, and a formulas walkthrough. No macros.
150 rows: task, category and priority from dropdowns, due date, ✓ to finish. Status and days left against an 'as of' date; done rows greyed and struck through, overdue red, due today or soon yellow. Tasks, done, overdue and progress with a bar at the top.
Ten overdue and ten due-soon tasks with due date, priority and days — found by INDEX/MATCH on numbered helper columns, no array formulas. Done in the last 7 days, open with no date.
Category × status counts with progress bars; open, overdue and done per person and per priority.
As-of date, due-soon horizon, categories, priorities, people.
Twelve formulas explained: the status chain, the running-count numbering, the lookups, why '<>Done' is done by subtraction.
Every workbook is recalculated in LibreOffice and by a second, independent formula engine on the sample data; the totals are compared with numbers worked out outside any spreadsheet, and every formula cell is scanned for errors. We don't run Excel itself on the build machine, so this says built for, not tested in — open the live preview to see the numbers the formulas produce.
What that means app by app: in Google Sheets, in Apple Numbers, in LibreOffice Calc.
The home page and its CSS — enough to publish a one-pager. A credit link stays in the footer.
Every page, the Pro-only pages, the source files, no attribution, and 12 months of updates and email support.
Use it for unlimited personal and commercial purposes, including client work.
Do not resell the spreadsheet itself, alone or in a bundle.
Task tracking in a spreadsheet works when the sheet, not you, works out what’s overdue.
Most task templates are a table with a checkbox. This one has an “as of” date, and every row compares its due date to it: before is Overdue, equal is Today, within a week is Soon. Put a ✓ in Done and the row greys out and stops counting. The top of the sheet keeps the score — tasks, done, overdue, progress with a bar.
The ✓ comes from a dropdown rather than a native checkbox because checkboxes are new in Excel,
absent in older versions and different in Numbers; a validated cell works everywhere, and any
mark counts. The Yes/No drop-down guide sets out that trade-off in full — when the native
checkbox is the better choice, and what COUNTIF reads in each case.
Focus is the sheet you’d open on Monday: the overdue tasks, then what’s due today or this week, each with its date, priority and days — and how many you finished in the last seven days. Board counts tasks per category and status with progress bars, and per person and priority. Setup holds the date, the horizon and the three dropdown lists.
“Show me the overdue tasks” is a filter — and FILTER doesn’t exist in Excel 2016 or Numbers.
Instead, a helper column numbers the overdue tasks 1, 2, 3 with a running COUNTIF, and Focus
looks up number 1, 2, 3 with INDEX/MATCH. The same trick lists what’s due soon. Both columns
are visible on Tasks, greyed, explained on the Formulas sheet.
The build recalculates both workbooks in LibreOffice and in a second, independent engine and compares forty-nine values — every status on the sample list, days left, the summary, the helper numbering, the Focus lists row by row, the Board counts — against numbers computed outside Excel.
First release
A wedding budget by category — estimated, actual, paid — with what's still to pay, over or under, and the honest budget left. Pro adds vendors with quotes, contracts, deposits and balance-due flags that feed the actuals, and a timeline whose dates follow the wedding date. No macros.
One row per invitation: adults and kids, RSVP, meal, table, gift and thank-you. Invited, responded, coming, meals per choice and what's missing for each Yes are counted. Pro adds tables with free seats, a budget with cost per head, and a timeline of tasks with what's late. No macros.
A task list with a Gantt chart drawn entirely by conditional formatting — no shapes, no macros. Start and end dates make the bar, Done % fills it, Blocked turns it red, a line marks this week. Pro adds a 26-week timeline, a Dashboard, Milestones and a formulas walkthrough.