A project tracker keeps every task, owner, deadline and status in one place, so you always know what is done, what is late and what comes next. You do not need special software for a small team or a freelance project: Excel can do it with a table, a few drop-downs, some date formulas and conditional formatting. This guide shows how to build a project tracker step by step, with a small example that you can check by hand. It covers the columns to include, status and priority drop-downs, formulas for days left and overdue tasks, a percent complete figure, a summary block, a progress bar and a simple Gantt style timeline, plus tips for sharing the file with a client or team.
Updated November 2026
In this guide
- Decide what the tracker must answer
- Step 1: set up the columns
- Step 2: add drop-downs for status and priority
- Step 3: calculate days left
- Step 4: flag overdue tasks
- Step 5: percent complete
- Step 6: build a summary block
- Step 7: add a progress bar
- Step 8: a simple Gantt style timeline
- Share and maintain the tracker
- Worked example: reading the tracker on 18 November
- Quick recap
- Practice problems
- Common mistakes
Decide what the tracker must answer
A useful tracker answers four questions at a glance: what has to be done, who is responsible, when is it due and what is the status. Add a fifth if you manage several projects: which project does the task belong to. Keep the first version simple, with one row per task, and add columns only if you really use them. Too many columns make people stop updating the file, and an outdated tracker is worse than none.
Step 1: set up the columns
Use these headings in row 1: Task ID, Task, Owner, Priority, Start date, Due date, Status, Days left, Notes. Add sample rows like the ones below and convert the range to an Excel table with Insert, Table, so that formulas and formatting extend to new rows automatically.
| Task ID | Task | Owner | Priority | Start | Due | Status |
|---|---|---|---|---|---|---|
| 1 | Write brief | Ali | High | 2 Nov 2026 | 6 Nov 2026 | Done |
| 2 | Design layout | Sara | High | 9 Nov 2026 | 16 Nov 2026 | In progress |
| 3 | Build pages | Omar | Medium | 17 Nov 2026 | 27 Nov 2026 | In progress |
| 4 | Client review | Hina | Medium | 30 Nov 2026 | 4 Dec 2026 | Not started |
| 5 | Launch | Ali | High | 7 Dec 2026 | 11 Dec 2026 | Not started |
Step 2: add drop-downs for status and priority
Drop-downs keep the entries consistent, so your counts and filters work. Select the Status column, go to Data, Data Validation, choose List, and type Not started, In progress, Done, Blocked. Do the same for Priority with High, Medium, Low. If you keep the lists on a separate sheet, the drop-downs can use a range, as explained in our drop-down list guide. Add an error alert so that nobody can type a different word. Consistent values are the foundation of a tracker that you can summarize and filter.
Step 3: calculate days left
In the Days left column, use =F2-TODAY(), where F holds the due date. If today is 18 November 2026, the Build pages task due on 27 November has 9 days left, the Client review task due on 4 December has 16 days left, and Launch due on 11 December has 23 days left. The Design layout task due on 16 November shows minus 2, which means it is two days late. To avoid showing days left for finished tasks, wrap the formula: =IF(G2="Done","",F2-TODAY()). A negative number is an easy signal for an overdue task, and you can colour it red with conditional formatting.
Step 4: flag overdue tasks
Select the Status and Due date columns, and add a conditional formatting rule with the formula =AND($G2<>"Done",$F2<TODAY()). Choose a red fill. Any task that is not done and whose due date has passed turns red. Add another rule for Done with a green fill, and one for Blocked with an orange fill. On 18 November, only task 2 is red, because it is not done and was due on 16 November. The not equal operator is explained in our not equal to guide. A tracker with clear colors helps a team see problems in seconds.
Step 5: percent complete
The simplest measure is the share of tasks that are Done. Use =COUNTIF(G2:G6,"Done")/COUNTA(G2:G6), which returns 1 out of 5, or 20 percent for the sample. Format it as a percentage. For a more accurate measure, add a column named Weight or Hours, and calculate the percent complete by weighted effort with SUMIFS: =SUMIFS(Hours,Status,"Done")/SUM(Hours). If the five tasks have hours of 4, 12, 20, 6 and 3, the Done hours are 4 out of 45, which is 8.9 percent. The weighted figure is more honest when tasks differ in size, and clients often ask for it.
Step 6: build a summary block
Put a small summary at the top of the sheet. Show the number of tasks with =COUNTA(B2:B6), which is 5. Show counts by status with COUNTIF, such as =COUNTIF(G2:G6,"In progress"), which is 2. Show the number of overdue tasks with =COUNTIFS(G2:G6,"<>Done",F2:F6,"<"&TODAY()), which is 1 on 18 November. Show the next due date with =MINIFS(F2:F6,G2:G6,"<>Done"), which is the earliest due date among tasks that are not done. Our COUNTIFS guide explains the counting formulas. A summary block turns a list into a dashboard that you can read in five seconds.
Step 7: add a progress bar
Select the percent complete cell, go to Home, Conditional Formatting, Data Bars, and pick a solid fill. The cell shows a bar that grows with the percentage. For text bars that work in any cell, use =REPT("█",ROUND(B1*10,0))&REPT("░",10-ROUND(B1*10,0)), which draws ten blocks, with two filled blocks at 20 percent. Data bars are simple and look good in a client report. Keep the bar next to the number, so the reader gets both the picture and the exact figure.
Step 8: a simple Gantt style timeline
To see tasks on a calendar, add columns for each week or day, with the dates in the header row. In the first cell of the first task use =AND(J$1>=$E2,J$1<=$F2), which returns TRUE when the date in the header falls between the start and the due date. Fill it across and down, then apply conditional formatting that fills the cell when the value is TRUE, and hide the text with a white font. The result is a bar for each task across the dates. For the sample, the Build pages bar covers 17 to 27 November. Freeze the first columns, as shown in our freeze panes guide, so that task names stay visible while you scroll the timeline.
Share and maintain the tracker
If several people update the file, store it in a shared cloud folder so that everyone sees the latest version, and agree on who updates which columns. Protect the formula columns, such as Days left, and leave the inputs unlocked. Add a Last updated date in a header cell. Hold a short weekly review where you filter for Overdue and Blocked tasks and decide what to do. Archive finished projects to another sheet or a copy of the file, to keep the active list short. For a client, hide helper columns and add a notes sheet that explains the colors and statuses.
Worked example: reading the tracker on 18 November
With the five sample tasks and a report date of 18 November 2026, the summary shows 5 tasks, 1 done, 2 in progress, 2 not started and 1 overdue. The overdue task is Design layout, which was due on 16 November, so its Days left value is minus 2 and the row is red. The next deadline among open tasks is the same overdue task, and after it the Build pages task on 27 November with 9 days left. The percent complete is 20 percent by task count. The project manager can see immediately that the design delay will squeeze the build and review stages, so the next step is to ask Sara for a new date or add help. If Sara marks the task as In progress with a new due date of 20 November, the red color disappears, Days left becomes 2, and the overdue count drops to 0. This is how a tracker supports a weekly meeting: you open it, filter for red and orange rows, and decide on actions in a few minutes, without scrolling through email threads or asking each person for an update.
Quick recap
Use one row per task with an owner, dates and a status drop-down. Calculate days left with TODAY, flag overdue tasks with conditional formatting, summarize with COUNTIF, COUNTIFS and MINIFS, show progress with a data bar, and add a Gantt style grid if you need a timeline. Keep it simple, protect formulas, and review it every week.
Practice problems
Try these. Problem 1: with today as 18 November, a task due on 25 November has 7 days left. Problem 2: a task due on 10 November that is not done is 8 days late. Problem 3: if 6 of 15 tasks are done, the percent complete is 40 percent. Problem 4: if a task starts on 3 November and is due on 7 November, it lasts 5 days counting both ends, or 4 days between the dates. Problem 5: add a new task with status Blocked and check that the colors and the summary update. Test your tracker with a done task, a late task, a future task and a blocked task.
Common mistakes
The most common mistake is to build too many columns, so nobody maintains the sheet. Another is to type statuses by hand instead of using a drop-down, so the counts miss variants. A third is to enter dates as text. A fourth is to forget to mark finished tasks as Done, so they show as overdue. A fifth is to leave out an owner, since a task without an owner is unlikely to be finished. Keep the file simple, review it every week, and treat it as a living document.
Frequently asked questions
How do I make a project tracker in Excel?
Create a table with task, owner, dates and status, add drop-downs, formulas for days left, and conditional formatting for overdue tasks.
How do I calculate days left to a deadline?
Subtract TODAY from the due date.
How do I show overdue tasks?
Use conditional formatting with a formula that checks that the status is not Done and the due date has passed.
How do I calculate percent complete?
Divide the number of Done tasks by the total number of tasks, or use weighted hours.
Can I make a Gantt chart in Excel?
Yes. Use conditional formatting on a date grid, or a stacked bar chart.

