A weekly status report in Excel can show which tasks are finished, overdue, blocked, or awaiting approval without requiring a complex project tool. This six-column template uses eight fictional tasks and formulas tied to a fixed reporting date, so you can reproduce every number before adapting it for your team.
What should a weekly status report in Excel include?
For a practical weekly review, capture the deliverable, one accountable owner, its deadline, a controlled status, and the next action or evidence. Add a unique task ID to make follow-ups unambiguous. The result is a simple operational snapshot: leaders can see the workload and identify the decisions needed, rather than searching an email thread for the latest estimate.
Use a clear reporting cutoff. The worked example below is a snapshot taken on Friday, November 6, 2026. It shows the status of all eight listed tasks as of that day, not a historical measurement of work finished only during that week. For an actual weekly-completions metric, record a separate completion date in your source system.
Copy this six-column task table into Excel
Create a worksheet named Tasks. Put these exact six headers in cells A1:F1. Enter the rows beneath them, keeping the due dates as genuine Excel date values rather than text. The names and assignments are fictional, and the dates are fixed to make the example repeatable.
| A — Task ID | B — Deliverable | C — Owner | D — Due date | E — Status | F — Next step / evidence |
|---|---|---|---|---|---|
| T01 | Ship onboarding guide | Maya | 2026-11-03 | Completed | Approved version sent |
| T02 | Update client FAQ | Leo | 2026-11-06 | Completed | Revision delivered |
| T03 | Check supplier pricing | Priya | 2026-11-05 | In Progress | Confirm two quotations |
| T04 | Approve revised contract | Sam | 2026-11-04 | Awaiting Approval | Finance sign-off required |
| T05 | Fix export bug | Leo | 2026-11-02 | Blocked | API owner to investigate |
| T06 | Draft training deck | Maya | 2026-11-09 | In Progress | Circulate first draft |
| T07 | Review onboarding metrics | Priya | 2026-11-10 | Not Started | Request latest data |
| T08 | Sign off client email | Sam | 2026-11-06 | Awaiting Approval | Manager decision today |
Select A1:F9 and choose Home > Format as Table, marking that the table has headers. This enables filtering and supports future expansion. Microsoft documents the table creation steps and explains how structured table references adapt when rows are added; the initial formulas below use fixed ranges so you can check their outputs against the supplied eight rows.
Calculate completion, overdue, blocked and approval counts
Type Report date in G2 and enter 2026-11-06 as a real Excel date in H2. Put the metric labels in G4:G10 and the corresponding formulas in H4:H10. Format H6 as a percentage. The overdue rule excludes completed items and blank due dates; an item due on the reporting day is not overdue yet.
| Cell | Metric | Exact Excel formula | Expected output |
|---|---|---|---|
| H4 | Total tasks | =COUNTA(A2:A9) | 8 |
| H5 | Completed | =COUNTIF(E2:E9,"Completed") | 2 |
| H6 | Completion share | =IFERROR(H5/H4,0) | 25% |
| H7 | Overdue and unfinished | =COUNTIFS(A2:A9,"<>",D2:D9,">0",D2:D9,"<"&$H$2,E2:E9,"<>Completed") | 3 |
| H8 | Blocked | =COUNTIF(E2:E9,"Blocked") | 1 |
| H9 | Awaiting approval | =COUNTIF(E2:E9,"Awaiting Approval") | 2 |
| H10 | Open | =H4-H5 | 6 |
Excel COUNTIFS applies all specified conditions to corresponding rows; COUNTIF handles a single status. In this data, T03, T04 and T05 are overdue. T05 is also blocked, while T04 is also awaiting approval. These categories overlap: never add overdue, blocked and awaiting-approval counts together and present the sum as the number of distinct outstanding tasks.
The 25% result means two of eight current records are marked Completed. It does not claim that a quarter of the week’s planned work was finished, that work was equally difficult, or that completion occurred between Monday and Friday. If your audience needs a measure of completed work during a particular week, add a verified completion timestamp and calculate against that separate field.
Keep input labels consistent and make overdue items visible
Free-typed status variants can spoil summary counts. Select E2:E100, open Data > Data Validation, choose List, and use Not Started,In Progress,Awaiting Approval,Blocked,Completed as the source. Set an error alert appropriate to your team’s editing process. Microsoft’s data-validation guide documents the dropdown controls; it cannot prove that a human entered a truthful status.
For a visual late-item flag, select A2:F100 and use Home > Conditional Formatting > New Rule > Use a formula. Enter =AND($A2<>"",ISNUMBER($D2),$D2<$H$2,$E2<>"Completed") and apply a restrained pale-red fill. The task ID guard prevents unfilled template rows from being shaded. Keep the report date in H2 for an auditable snapshot rather than using TODAY(), which would change the meaning of yesterday’s saved report when reopened.
In a team workbook, consider protecting formula cells against accidental edits and asking owners to record dated evidence in the Next step / evidence field. Conditional formatting changes how a row looks, not who owns it or whether a deadline has been formally changed. For more formatting variations, see the Excel overdue-task highlighting guide.
Turn the numbers into a concise management update
Decision-makers need an interpretation, not a pasted dashboard. Use this copy-ready message, substituting your actual people and dates. The figures correspond exactly to the example above; do not turn the fictional risks into claims about a real team.
Weekly operations update — November 6, 2026. We have 8 tracked tasks: 2 completed (25%), 6 still open, 3 overdue, 1 blocked, and 2 awaiting approval. The export bug is blocked pending input from the API owner, and the revised contract needs Finance sign-off. Please confirm the contract approval route and the priority for the bug fix; next week we will progress the training deck and onboarding review. I will refresh this snapshot at the next reporting cutoff.
Notice how the message separates a decision request from routine progress. T08 is awaiting approval but due today; it belongs in the approval count, not the overdue count. T04 appears in both approval and overdue views. If nothing has changed on one item, name the latest checkpoint and next action rather than inventing activity; see how to give an update when there is no progress.
For a fuller written narrative, the existing weekly status update guide explains how to present accomplishments, blockers and next priorities. This Excel version deliberately does something different: it supplies the six source fields, formulas and reproducible totals behind that message.
How to reuse the template each Friday without losing history
First, agree when statuses are frozen: for example, Friday at 4 p.m. Set H2 to that cutoff date and ask each owner to update the source rows before it. Second, save a dated copy, or export a PDF for the management record. Third, carry unfinished items forward with their original deadlines unless an authorized change has been documented. Replacing the original due date silently would erase evidence of delay.
When new tasks are added, expand the fixed formula ranges beyond row 9 or change the source to an Excel Table with structured references. Otherwise a ninth task can fall outside your summary. Filter the table to inspect an individual owner, but remember that ordinary COUNTIF and COUNTIFS formulas still count hidden or filtered-out rows; the summary here intentionally covers the complete dataset. The Excel and spreadsheets hub collects related formula and maintenance guides.
If your team manages several distinct types of follow-up rather than one weekly task register, the Office Control Logs & Trackers Kit is a separate US$12, macro-free Excel workbook with six specialized logs and a calculated dashboard. It is not represented as containing the specific sample formulas above; this article’s six-column sheet works independently.
Common mistakes and frequently asked questions
Why is my overdue count higher than my blocked count?
Overdue means an unfinished dated task passed its cutoff; blocked means its status says work cannot proceed. A task can be both. Review the rows, not just the two totals, to identify distinct affected tasks and the responsible next action.
Why does Excel show zero when a date looks earlier?
The due-date cell may contain text rather than a numeric Excel date, or the cutoff in H2 may be text. Enter dates as real date values, format them consistently, and review any imported data before trusting the result. The ISNUMBER check in the highlighting rule deliberately ignores text dates.
Can this six-column sheet measure tasks completed this week?
Not reliably. It identifies records currently marked Completed, but it has no completion-date field. For period-specific throughput, use a seventh field or a separate activity history that records actual completion dates. Do not relabel the 25% snapshot figure as weekly throughput.
Should I share the editable workbook with every manager?
That depends on your team’s access rules. An editable version is useful for task owners; a date-stamped read-only copy is often clearer for people who only need decisions and risks. Remove sensitive notes before distribution, and keep approval authority outside the spreadsheet unless officially delegated.
Bottom line
A useful weekly Excel report needs one consistent task register, a fixed cutoff and a few transparent counts. Start with the eight example rows and confirm the 8 / 2 / 25% / 3 / 1 / 2 / 6 results; then replace the fictional tasks with real entries, preserve a dated snapshot and send a short request for any decisions that are blocking progress.