Free Daily Task Tracker Template (Excel)
What's inside the free daily task tracker template
One Tasks sheet, up to 150 rows. Each row is a task with a priority (High, Medium, Low), an assigned day (Mon-Sun), a due date and a status (To do, In progress, Done) - and an Overdue column that calculates itself.
The summary below the table shows your overall completion rate, a count of overdue tasks, how many tasks were completed on each day of the week, and how many high-priority tasks are currently overdue.
How the Overdue flag and completion rate calculate
Overdue reads Yes the moment a task's due date is before today and its status isn't Done - mark a task Done and it always reads No, no matter the date. This check compares the due date against today only, not the assigned day, so a task due Friday shows Overdue starting Saturday if it's still open.
Completion rate divides the number of tasks marked Done by the total number of tasks you've entered - it updates the instant you change a Status cell, with no manual recalculation.
Rollup by day and priority
Because every task also carries an Assigned day and a Priority, the summary can show completed-task counts broken out by day (how many tasks got done Monday vs. Friday) and flag how many High-priority tasks are currently sitting overdue - useful for spotting whether your most important work is the work actually slipping.
This is one linked sheet, not seven separate daily tabs pasted together - add or edit a row once and every rollup recalculates.
Who this template is for
Anyone managing a personal or small-team daily to-do list who wants an automatic overdue flag and a completion-rate summary, instead of a static checklist with no calculation.
For sprint-based team work with capacity and velocity, a dedicated sprint planning template is a better fit than a daily task list.
How to use it
- Add one row per task: priority, the day it's assigned to, due date and status.
- Overdue marks itself Yes automatically once the due date has passed and the task isn't Done.
- Check the summary for your overall completion rate and tasks completed per day.
- Watch the high-priority overdue count to catch your most important slipping tasks first.
Download the free Free Daily Task Tracker Template (Excel)
No spam — template updates and new free templates only. Unsubscribe anytime.
Frequently asked questions
How does the Overdue flag decide a task is late?
It checks Status first: Done always reads No. Otherwise, if the due date is before today, it reads Yes; if not, it reads No.
Does Overdue check the assigned day or the due date?
The due date only. Assigned day is a separate column used for the day-by-day completion rollup, not for the Overdue check.
How is the completion rate calculated?
Tasks marked Done divided by the total number of tasks entered on the sheet - it recalculates automatically as you add tasks or change a Status cell.
Can I use this in Google Sheets?
Yes. Upload the downloaded file to Google Drive, then open it and choose File > Save as Google Sheets. The overdue flag and every rollup keep working.
How many tasks can I track?
The Tasks sheet is built for up to 150 rows. For a larger list, add rows and extend the summary's COUNTIFS ranges.
What's the usage license?
Personal use or use within one business. It's not meant to be resold or redistributed as a template product.