To-Do & Task Tracker: Status, Due Dates, Overdue Flags & % Done
All lessons
- Habit Tracker: x Marks, COUNTIF per Habit & a Streak CounterFree
- To-Do & Task Tracker: Status, Due Dates, Overdue Flags & % DoneFree
- Expense Tracker: Categories, SUMIFS by Month & Budget vs Actual Pro
- Reading Goal Tracker: Progress %, Pace Needed per Day & On Track? Pro
- Workout Log: Volume, Week Numbers, Weekly Totals & Personal Bests (MAXIFS) Pro
- Mini-Gantt Project Timeline: Durations & Formula Rules that Shade the Weeks Pro
- Savings Goal Tracker: Running Balance, Progress % & Months to Goal (with a Chart) Pro
- Tracker Dashboard: KPIs from Every Tracker & a Budget vs Actual Chart Pro
You are not signed in — the lab works, but your progress is not saved. Start free
Read first
In Excel: make it live
- Replace
$B$16withTODAY(), or put=TODAY()in B16 so all formulas keep pointing at one cell. - Add a drop-down for the status: Data > Data Validation > List, Source
To do,In progress,Done. Typos like "done " would otherwise break COUNTIF. - Format the list as a table (
Ctrl+T): new rows copy the formulas in E and F automatically.
Loading the spreadsheet…