Free Excel template · Excel for students
Free Excel assignment tracker for students
For students with several classes and a syllabus for each. List every assignment once with its due date and how much of the grade it is worth; the template counts the days left, labels each one Overdue, Due soon, This week or Later, and shows how many open assignments and how much of your grade are due in the next 7 days.
Preview and try it
This is the template's sheet, calculated by the same engine as the Cellwise app. Change any number to see the formulas react before you download.
| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
| 1 | Assignment tracker | ||||||
| 2 | Today's date | Nov 2, 2026 | |||||
| 3 | |||||||
| 4 | Course | Assignment | Due | % of grade | Done? | Days left | Status |
| 5 | Calculus I | Problem set 7 | Nov 6, 2026 | 0.02 | 4 | This week | |
| 6 | English Comp | Essay draft | Nov 4, 2026 | 0.1 | 2 | Due soon | |
| 7 | Chem Lab | Lab report 4 | Nov 5, 2026 | 0.05 | Yes | 3 | Done |
| 8 | Chemistry | Midterm 2 | Nov 12, 2026 | 0.2 | 10 | Later | |
| 9 | Intro Psychology | Reading quiz | Oct 30, 2026 | 0.01 | -3 | Overdue | |
| 10 | Spanish II | Oral presentation | Nov 17, 2026 | 0.1 | 15 | Later | |
| 11 | Calculus I | Problem set 8 | Nov 13, 2026 | 0.02 | 11 | Later | |
| 12 | English Comp | Final essay | Dec 4, 2026 | 0.25 | 32 | Later | |
| 13 | |||||||
| 14 | |||||||
| 15 | |||||||
| 16 | Overdue | 1 | |||||
| 17 | Open in the next 7 days | 2 | |||||
| 18 | Share of grades due in the next 7 days | 0.12 | |||||
| 19 | Next deadline | Essay draft |
How the formulas work
Days left until each due date
Excel stores dates as day numbers, so the due date minus today's date is the number of days left. A negative number means it is past due. The $ signs keep every row pointing at the date in B2. Replace that date with =TODAY() to keep the tracker current every time you open it.
A status that updates itself
The IFs are checked in order and the first one that is true wins: done work shows Done even if its date has passed, then anything below 0 days is Overdue, 0 to 2 days is Due soon and so on. Add color with Home > Conditional Formatting > Highlight Cells Rules > Text that Contains, "Overdue".
How much of your grade is due this week
SUMIFS adds the % of grade column for open assignments due in the next 7 days. "<>Yes" means anything except Yes, so empty Done cells count. In the sample, 12% of a grade is due in the next week (the essay draft and a problem set); the Chemistry midterm joins the total once it is 7 days away.
Your next deadline
FILTER keeps open assignments that are not overdue, SORT orders them by the 5th column of that block (Days left, smallest first) and INDEX takes the first name. Needs Excel 2021, Microsoft 365 or Google Sheets.
Make it yours
- At the start of term, copy every deadline from each syllabus in one sitting. It takes 20 minutes and is the most useful thing you will do all term.
- Sort by the Due column (Data > Sort) whenever you add new rows so the list reads in order.
- Need more rows? Insert them above row 14 and copy the formulas in F and G down. The summary formulas widen automatically when you insert inside their ranges.
- Put big projects in as several rows (outline, draft, final) with their own dates so they never turn into a single panic.
FAQ
How do I track assignments and due dates in Excel?
List each assignment with its due date, subtract today's date to get days left (=C5-TODAY()), and use IF to label it Overdue, Due soon or Later. This template does all of that and adds a weekly summary.
How do I count days until a due date in Excel?
Subtract today from the due date: =C5-TODAY(). For school days only, use =NETWORKDAYS(TODAY(),C5), which skips weekends and can also skip a list of holidays you give it.
Can I use this assignment tracker on my phone?
Yes. Open the .xlsx in the Excel mobile app, or upload it to Google Drive and open it with Google Sheets. The formulas work in both.
Functions used
IFPicks a result from a testCOUNTIFCounts cells that matchCOUNTIFSCounts with several conditionsSUMIFSAdds with several conditionsIFERRORFallback when a formula errorsINDEXValue at a positionSORTSorts a range, spillsFILTERKeeps matching rows, spills
Related guides
- How to calculate days between two dates in Excel
- How to write a nested IF in Excel
- COUNTIFS with multiple criteria in Excel
More free templates
- GPA calculator templateFor high school and college students who want to know their GPA now and what it takes to reach a goal.Free .xlsx
- Expense report templateFor employees who need to claim back business costs, and for the managers and bookkeepers who check those claims.Free .xlsx
- Purchase order templateFor small businesses, office managers and buyers who send purchase orders to suppliers and want to track what actually arrives.Free .xlsx
- Accounts receivable aging report templateFor owners, bookkeepers and credit controllers who invoice customers on terms and need to see who owes what and for how long.Free .xlsx
Updated