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.
Formula cells are locked so a stray keystroke can't break the math; input cells stay editable. To change a formula or the layout in Excel, go to Review → Unprotect Sheet and enter the password tt.
Download the free Daily Task Tracker Template (Excel)
The offers include our paid versions of the templates. Privacy
Project Management Pack
If daily tasks are part of a larger project you need to plan and report on, the paid Project Management Pack adds a Gantt chart, status report and budget tracker alongside task tracking.
See the full versionFrequently 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.