Excel for project management: a task tracker you build yourself
For small and mid-sized projects, a well-built Excel sheet is often all the planning tool you need. Set up a task list, calculate working days, flag late tasks automatically and turn the dates into a simple Gantt chart, with exercises for the key formulas.
In short: a project plan in Excel is a table with one row per task, dates that Excel can calculate with, a status column driven by formulas and a timeline colored by conditional formatting. Four functions do most of the work: NETWORKDAYS, IF, AND and COUNTIF.
When Excel is the right tool for a project
Excel works well when one person or a small team keeps the plan, the project has a few dozen tasks and the main questions are "what is due, what is late and how far along are we?". Everyone already has it, and you can shape the sheet exactly to your project.
It gets harder when many people update the plan at the same time, when tasks depend on each other in long chains that should move automatically, or when you need to balance people across several projects. Dedicated project management tools handle those cases better. The skills on this page still carry over, because most of those tools export to Excel for reporting.
Step 1: Set up the task list as a table
Start with one row per task and these columns: task, owner, start, end, working days, percent done and status. Then select the range and format it as a table. New tasks added at the bottom inherit every formula and format, and the filter buttons let you show only one owner or only open tasks.
The formulas further down assume this order: task in A, owner in B, start in C, end in D, working days in E, percent done in F and status in G. Give the cell with the status date the name StatusDate by typing it into the Name Box left of the formula bar. Formulas that read StatusDate are easier to follow than ones full of dollar signs.
Two details save trouble later. Enter dates as real dates, not as text like "next Monday", so Excel can calculate with them. And restrict owner and status to a drop-down list, so "Anna" and "anna " do not count as two people.
Step 2: Durations in working days
Calendar days are misleading in a plan, because weekends and holidays do not get work done. NETWORKDAYS counts only Monday to Friday and skips a list of days off.
Task In D2, calculate how many working days the task takes. Weekends do not count, and neither do the days off in F2:F3. The formula is filled down to D6 and must always use the same list of days off.
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Task | Start | End | Working days | Days off | |
| 2 | Planning | 1/5/2026 | 1/9/2026 | 1/15/2026 | ||
| 3 | Design | 1/12/2026 | 1/23/2026 | 2/10/2026 | ||
| 4 | Build | 1/26/2026 | 2/13/2026 | |||
| 5 | Testing | 2/16/2026 | 2/23/2026 | |||
| 6 | Go-live | 2/24/2026 | 2/24/2026 |
The opposite question comes up just as often: a task needs 8 working days and starts on a given date, so when does it end? =WORKDAY(C2,8-1,Holidays) returns the end date, where Holidays is a named range with the days off. The minus one is there because the start day counts as the first working day. If your team works a different week, NETWORKDAYS.INTL and WORKDAY.INTL let you set which days are the weekend. More date tools are in the lesson on date functions.
Step 3: Flag late tasks with IF and AND
A status column that you type by hand is out of date the moment you stop looking at it. A formula that compares the due date with a status date keeps itself current. A task counts as late when two things are true at once: it is not finished and its due date has passed.
Task A task is late when it is not 100% done and its due date is before the as-of date in F1. In D2, write a formula that returns "Late" in that case and "On track" otherwise. It is filled down to D7.
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Task | Due | % done | Status | As of | 2/17/2026 |
| 2 | Planning | 1/9/2026 | 100 | |||
| 3 | Design | 1/23/2026 | 100 | |||
| 4 | Build | 2/13/2026 | 80 | |||
| 5 | Testing | 2/23/2026 | 40 | |||
| 6 | Training | 2/12/2026 | 90 | |||
| 7 | Go-live | 3/9/2026 | 0 |
In your own tracker, put =TODAY() in the status date cell so the flags update every day. IF combined with AND and OR handles most status rules. For three states in the full tracker, nest a second IF: =IF(F2=100,"Done",IF(D2<StatusDate,"Late","Open")).
Step 4: Measure progress
There are three common ways to express how far a project has come, and each answers a slightly different question:
| Measure | Formula | Tells you |
|---|---|---|
| Share of tasks done | =COUNTIF(F2:F7,100)/COUNTA(A2:A7) | How many tasks are finished, regardless of size |
| Average completion | =AVERAGE(F2:F7) | Average percent done, every task weighted equally |
| Weighted by duration | =SUMPRODUCT(E2:E7,F2:F7)/SUM(E2:E7) | Progress where long tasks count more than short ones |
The weighted version is usually the most honest, because finishing a one-day task should not move the needle as much as finishing a three-week one. COUNTIF also answers quick questions such as how many tasks are late: =COUNTIF(G2:G7,"Late").
Step 5: A simple Gantt chart with conditional formatting
You do not need a chart object for a Gantt view. Put dates across a row, for example one column per working day or per week starting in I1, and let conditional formatting color every cell that falls inside a task's start and end:
=AND(I$1>=$C2,I$1<=$D2)
Apply the rule to the whole grid, such as I2:AL7. The mixed references do the work: I$1 always reads the date from the header row, and $C2 and $D2 always read start and end from the task's own row. If those dollar signs are unclear, the lesson on absolute references explains them. A second rule, =I$1=StatusDate, marks the column of the status date. Narrow columns and no gridlines make the bars easy to read.
Habits for project sheets that stay useful
Formulas for anything that can be calculated
Durations, status and progress should come from formulas. People then only update dates and percent done, and everything else follows.
One status date
Every comparison with "today" should point to the same cell. That way you can also look at the plan as of last Friday by changing one value.
Sort and filter instead of extra sheets
Instead of copying tasks into a separate list per owner, use sort and filter on the table. One list means one version of the truth.
FAQ
Is Excel good for project management?
For small and medium projects with a few dozen tasks and one person maintaining the plan, yes. For large projects with many dependencies and many people editing at once, a dedicated project tool is more practical.
How do I calculate working days between two dates in Excel?
Use =NETWORKDAYS(start,end). It counts Monday to Friday, including both dates. Add a range of holidays as the third argument to leave those out too.
How do I make a Gantt chart in Excel?
The quickest way is conditional formatting: dates across the top row, tasks down the side and a rule like =AND(I$1>=$C2,I$1<=$D2) that colors the cells between start and end. A stacked bar chart works too but takes longer to set up.
How do I show project progress as a percentage?
Divide finished tasks by all tasks with COUNTIF and COUNTA, or weight each task by its duration with =SUMPRODUCT(durations,percent_done)/SUM(durations).