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.
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.
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.
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 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.
An expense log for Excel and Google Sheets that totals itself: this month by category with data bars, twelve months back, and spending against the limits you set — every formula visible. Pro adds the Monthly and Limits sheets, a Setup sheet with limits, and a formulas walkthrough.
Habits down the side, days across the top, a mark when you did it. Done counts, a monthly target scaled from your weekly one, completion bars, weekends shaded. Pro adds current and best streaks with the running count on its own sheet, a by-week view, and a formulas walkthrough. No macros.