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.
Eight habits × 31 days. Any mark counts. Done, monthly target (weekly target scaled to the month), done % with a bar, per-day totals, month completion. Days past the month's end greyed.
One more than yesterday if marked, back to zero if not — the whole grid, so the streak arithmetic is visible. Current streak reads the last marked day; best is the max.
Done per habit per week of the month against the weekly target: green when met, yellow when short.
Month and habits with weekly targets.
Eight formulas explained, including the 'last marked day' trick without array-entered formulas.
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.
Put anything in a cell — a 1, an x, a tick — and it counts. Leave it empty and it doesn’t. Each habit has a weekly target; the sheet scales it to the month (3 a week in a 31-day month is 13) and shows done against it with a bar. Weekends are shaded so a run of blanks on Saturday makes sense; days past the end of a short month are greyed.
The Streaks sheet holds a running count for every cell: one more than the day before if
marked, zero if not. Current streak is the value on the last day you marked anything —
found with SUMPRODUCT(MAX(…)) rather than an array formula, so it works in Excel 2016 and
Numbers — and best streak is the row’s maximum. The Weeks sheet breaks the month into weeks
against the weekly target.
The build recalculates the workbook in LibreOffice and in a second, independent engine on the sample marks and compares fourteen values — done counts, scaled targets, current and best streaks for a habit with a gap and one without, the week splits — against numbers computed outside Excel.
First release
Names down the side, days across, one letter per cell — P, A, L, E, H — from a dropdown, coloured. Counts per person, attendance % that counts Late as present and leaves holidays out, present per day, weekends shaded. Pro adds a Summary with bars and flags, holidays from Setup, and a formulas walkthrough. No macros.
Stock levels, reorder points and stock value for Excel and Google Sheets, every number a visible formula. Status turns yellow at the reorder point and red at zero. Pro adds a Movements log that updates quantities, a Reorder list with the cost to restock, a Dashboard by category, and a formulas walkthrough.
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.