
When a deadline passes, an ordinary task list still looks the same. An assignment tracker can do more: show what to work on today, what has slipped and what is already complete. This layout works for a student balancing courses, a teacher planning tasks or a freelancer tracking deliverables.
Give each task its own row
Enter these headings in A1:D1. Use one row per assignment and enter real dates in columns B and C. For these examples, use Excel’s DATE function to avoid ambiguity between month-first and day-first date formats.
| Task | Due date | Completed on | Status |
|---|---|---|---|
| Revise project outline | =DATE(2026,11,12) |
||
| Send reading notes | =DATE(2026,11,14) |
||
| Prepare next lesson | =DATE(2026,11,18) |
||
| Submit practice quiz | =DATE(2026,11,13) |
=DATE(2026,11,13) |
|
| Choose presentation topic |
Put Report date in F1. Enter =DATE(2026,11,14) in F2 while testing. Format B:C and F2 as dates if Excel displays serial numbers.
Use the completion date first
Enter this formula in D2 and copy it down:
=IF(ISNUMBER(C2),"Complete",IF(B2="","No due date",IF(NOT(ISNUMBER(B2)),"Check due date",IF(B2<$F$2,"Overdue",IF(B2=$F$2,"Due today","Upcoming")))))
The formula checks completion first so submitted assignments stay complete after their deadlines pass. Then it checks whether the deadline is missing, whether the value is text and how the date compares with F2. The dollar signs keep every task pointed at the same report date when you copy the formula.
With the sample report date, the five statuses should read Overdue, Due today, Upcoming, Complete and No due date, in that order. Change F2 to November 19 and check that “Prepare next lesson” becomes overdue while “Submit practice quiz” stays complete. When the results match, replace the test date in F2 with =TODAY() for a working tracker that follows the current date when Excel recalculates.
Use it to decide what to do next
Filter Status for Due today and Overdue, then sort the filtered rows by Due date. Look at the oldest deadline and decide the next action. For a large deliverable, that action might be “draft the introduction” or “email the tutor to agree on a revised date.” Put it in a new Next action column if the assignment name alone leaves you guessing.
Review No due date separately. Those rows need a decision about timing before Excel can prioritise them. If a pasted due date triggers Check due date, re-enter it as a date, then verify that Excel displays the intended day and month. Completion dates should also be real dates: a word such as “done” in that column will leave the task open.
Keep a weekly snapshot when you need a record
A live tracker tells you where things stand now. If you need to see how your workload looked at the end of each week, make a dated copy and replace F2 in that copy with a fixed date. Later changes in the live file will then leave that snapshot intact.