How can I turn a list of task dates into a simple weekly workload view?
Quick answer
Keep the task list as your source of truth, with one task per row and a real date in each task’s date field. In a separate summary, list each week’s start date and the next week’s start date, then count tasks whose dates fall within those bounds. Choose and state a consistent week-start convention; dates can fall into different numbered weeks depending on that choice. [S1][S2]
The question, the details, the next step.
I have a task list with dates. What’s the simplest way to show the workload by week without rearranging or changing the task records?
Leave the task list intact and create a separate summary area or sheet. Set up columns for Week start, Next week starts, and Task count. Each summary row covers dates from its week start up to, but not including, the next week’s start. You can add one column per assignee if you want a breakdown by person.
Choose a week-start convention first and state it in the summary. Excel’s WEEKNUM supports different week-start settings and numbering systems, including ISO 8601; a date can be assigned to different numbered weeks under different conventions. Use real spreadsheet dates rather than ambiguous date text. [S1]
How do I count tasks in a week, including a separate count for each person?
Suppose task dates are in column A and assignees are in column B. In your separate summary, put a week’s start date in E2 and the following week’s start date in F2. Count task rows in that range with:
=COUNTIFS($A:$A,">="&E2,$A:$A,"<"&F2)
For an assignee named in G1, use:
=COUNTIFS($A:$A,">="&E2,$A:$A,"<"&F2,$B:$B,G$1)
COUNTIFS supports multiple conditions, including date bounds and an assignee. [S2] You can copy the formulas down for more weeks and across for more assignee headings. These formulas count matching rows; if a task appears in multiple rows, they count those rows rather than unique tasks.
Could you show a small worked example of the boundaries and the summary layout?
For an illustrative Monday-start week, suppose the summary row has a start date of Monday, 6 January 2025, and the next start date is Monday, 13 January 2025. If three task rows have dates from 6 through 12 January, the total for that row is 3. A task dated 13 January belongs in the next row, not both rows.
A simple summary can be written like this:
Convention: Monday-start weeks; end date is exclusive.
- Week starting 6 Jan | Next week starts 13 Jan | Total: 3 | Alex: 2 | Sam: 1
- Week starting 13 Jan | Next week starts 20 Jan | Total: formula | Alex: formula | Sam: formula
The sample counts are illustrative, not results from your task list. Enter the boundary dates as real dates. [S1][S2]
What should I check before sharing the view, and what can the counts tell me?
Check that the task date column contains real dates, each summary row has the intended start and next-start dates, and assignee names match the task list. Test a task on a week boundary: it should be counted in the week whose start is on or before its date, and before the following start date. Keep the summary separate so you do not need to alter the original task rows. [S2]
A count shows how many matching task rows fall in a date range. By itself, it does not show task effort, duration, priority, or whether someone is overloaded. If you need those answers, add appropriate information and a clearly defined measure rather than treating a task count as a full measure of workload.
A practical checklist
Keep the original task list unchanged and create a separate summary.
Choose and state a week-start convention.
Use real dates for task dates and week boundaries.
Count from the week start inclusive to the next week start exclusive.
Check that assignee labels match the task list.
Test a boundary date; remember that formulas count rows, not effort.
A few more useful answers
Should I use week numbers or date ranges?
Date ranges make the boundaries visible and work well for COUNTIFS. If you use week numbers, state the week-start and numbering convention; Excel supports different options, including ISO 8601. [S1]
Can I show a separate count for each assignee?
Yes. Add an assignee condition to the date-range count and use an assignee name as each summary heading. COUNTIFS supports multiple conditions, including date bounds and an assignee. [S2]
Does a task count show how busy someone is?
It shows the number of matching task rows, not their effort, duration, priority, or complexity. Treat it as a simple count, not a complete measure of capacity.
Sources
References used for this guide.
- [S1] WEEKNUM function support.microsoft.com · Checked
- [S2] Count numbers or dates based on a condition in Excel support.microsoft.com · Checked