To make an example project timeline in Excel, list each task with an owner, start date, and finish date, then add a row of working dates and use conditional formatting to shade the cells that fall within each task’s dates. The sample below builds a weekday Gantt-style timeline for a five-task project in Excel for Microsoft 365 on Windows.
What the example timeline shows
This example covers a short project running from Monday, April 6, through Friday, May 1, 2026. The task list gives the plan detail; the shaded date cells make the schedule easier to scan. The example uses five tasks, but the same layout works for a small personal project, a team plan, or a more detailed work schedule.
| Task | Owner | Start | Finish | Duration in workdays |
|---|---|---|---|---|
| Requirements | Mina | Apr 6, 2026 | Apr 7, 2026 | 2 |
| Wireframes | Leo | Apr 8, 2026 | Apr 10, 2026 | 3 |
| Build | Priya | Apr 13, 2026 | Apr 17, 2026 | 5 |
| Review | Omar | Apr 20, 2026 | Apr 21, 2026 | 2 |
| Launch prep | Mina | Apr 22, 2026 | Apr 24, 2026 | 3 |
The example leaves weekends out of the timeline headers, so each column represents a working day. It does not include public holidays, resource capacity, or task dependencies; those need to be added or managed separately if they matter to the project.
Set up the worksheet
Open a blank workbook and enter the project start date in B1. For this example, type April 6, 2026, into B1 and format it as a date. In row 3, add the task-list headings in A3:E3: Task, Owner, Start, Finish, and Duration (workdays). Enter the five tasks in rows 4 through 8, with their owners and start and finish dates in columns A through D.
Use actual Excel dates in the Start and Finish columns, rather than text that only looks like a date. A quick way to check is to select a date cell and look for a date format in Home > Number Format. If dates are stored as text, comparisons in the bar rule may not work as expected. Format the date columns consistently so that readers can distinguish dates from task names or notes.
- Keep one task per row, with a clear name and one owner or accountable role.
- Use the same start-and-finish convention throughout: both dates in this example count as scheduled workdays.
- Leave columns F onward for the calendar, and reserve a clear area above or beside it for the project name and status.
Calculate durations and build the date header
For a duration in working days, enter the formula below in E4, assuming each task’s start and finish are in C4 and D4. It returns 2 for the Requirements task, because April 6 and April 7 are both weekdays. Copy the formula down through E8. NETWORKDAYS excludes Saturday and Sunday by default; if a project calendar has holidays, you can supply a holiday-date range as its optional third argument.
With the start date in C4 and finish date in D4, enter =NETWORKDAYS(C4,D4) in E4. For the Requirements row, the result is 2 workdays.
Next, create the calendar header. In F3, reference the project start date in B1. In G3, use WORKDAY to advance to the next weekday, then fill the formula to the right through Y3. The range F3:Y3 holds 20 weekdays, April 6 through May 1, 2026. The formula in G3 returns April 7, 2026. WORKDAY skips weekends, but it does not know about your organization’s holidays unless you provide a holiday list as its optional third argument.
With the project start date in B1, enter =$B$1 in F3; it returns April 6, 2026. With F3 containing April 6, enter =WORKDAY(F3,1) in G3; it returns April 7, 2026. Drag G3’s fill handle to the right through Y3. Format the header cells as dates, and consider using a short format such as d-mmm to conserve space.
Turn the calendar into timeline bars
Select the schedule area F4:Y8. On the Home tab, choose Home > Conditional Formatting > New Rule, then select Use a formula to determine which cells to format. The rule compares each date in row 3 with the task’s start and finish dates in columns C and D. The dollar signs keep the date-row reference and the start-and-finish columns in place as Excel evaluates the rule across the selected range; the row numbers remain relative so each task uses its own dates.
With dates in F3:Y3 and task start and finish dates in C4:D8, use =AND(F$3>=$C4,F$3<=$D4) as the conditional-formatting formula for F4:Y8. For the Requirements row, the rule is true on April 6 and April 7, so those two cells receive the chosen fill color. Pick a fill in the formatting dialog and confirm the rule. A row of adjacent shaded cells forms that task’s timeline bar.
To make the schedule readable, use a restrained color for ordinary work and keep the task names visible at the left. You can widen columns A and B, make the date columns narrow, center the date headings, and freeze the task labels while scrolling. In Excel for Microsoft 365 on Windows, select the cell just below and to the right of the area to keep visible, then choose View > Freeze Panes > Freeze Panes. For this layout, selecting F4 before freezing keeps rows 1 through 3 and columns A through E visible. On Mac, use the View tab’s Freeze Panes command; the exact menu presentation can differ by Excel release.
Add milestones, dependencies, and status
A timeline bar shows when work is planned, not whether the work is complete or what must happen first. Add columns for Status, % Complete, or Notes if people need to update progress. For example, a status value such as Not started, In progress, or Done can complement the date bar. Agree on definitions before a team uses the status field; otherwise, different people may apply the same label differently.
Milestones are single-date events, such as approval or launch, rather than tasks that occupy several days. A straightforward approach is to include a milestone row with the same start and finish date. The conditional formatting rule will shade one date cell, which you can distinguish with a different fill or a symbol in a separate milestone column. If the symbol is important, label it in text as well; color alone is not a reliable way to communicate meaning.
Dependencies need explicit treatment. If Review cannot begin until Build is finished, show that relationship in a predecessor column, add a note, or use a project tool that can represent links and recalculate dates. The example rule does not move tasks automatically when another task slips. It only colors cells based on the dates currently entered. This distinction prevents a common misunderstanding: a formatted timeline is a visual schedule, not a complete project-management engine.
Choose the right time scale and level of detail
Daily columns are useful when tasks last a few days and the project spans a few weeks. For a project lasting several months, a daily grid can become too wide to print or review. A weekly scale may be clearer: each column can represent a week, and the team can agree whether the week’s date means its first workday or its week-ending date. Monthly columns work for high-level roadmaps, but hide short task overlaps and delays.
Match the number of rows to the decisions readers need to make. Breaking every small action into its own row creates maintenance work and can obscure the main delivery stages. On the other hand, a single row called Build may be too broad if separate teams need to see design, development, and testing dates. A useful test is whether someone reviewing the timeline can identify ownership, timing, and the next meaningful checkpoint without asking what a row includes.
Also decide whether the schedule uses calendar days or working days. WORKDAY and NETWORKDAYS treat Saturday and Sunday as nonworking days by default, but company calendars may include other nonworking dates or weekend patterns. For a holiday-aware workday header, list holiday dates in a range and include that range as WORKDAY’s third argument. Make the calendar assumption visible in a note so readers do not mistake a planned workday for a guaranteed available day.
Common problems and practical fixes
- Bars do not appear: Check that the selected conditional-formatting range is F4:Y8, that the rule formula refers to F$3 and $C4 and $D4, and that the task dates are real Excel dates. Open Home > Conditional Formatting > Manage Rules to inspect the rule and its Applies to range.
- Bars are shifted one day: Check whether the header dates and task dates use the same calendar, and whether the start and finish dates are intended to count inclusively. The example rule includes both endpoints.
- The date header includes weekends: Use WORKDAY for each next date rather than adding 1. If weekends should be shown, use consecutive calendar dates instead and make that choice consistent with the task-duration method.
- Dates display as numbers: Excel stores dates as serial values. Apply a date format through Home > Number Format; the underlying values can still be used in comparisons and calculations.
- The workbook is hard to read on screen or paper: Reduce the date range, use a weekly view, switch to landscape page orientation, or print only the relevant columns. Repeating a header row can also help on multi-page printouts.
One more maintenance issue is a timeline that looks current but is not. If a project start date changes, the header formulas update, but task dates typed directly into the rows do not automatically shift. That may be exactly what the project needs, since dates often need deliberate review. If dates should move according to dependencies, document the rule or use scheduling software rather than assuming the colored grid will recalculate the plan.
When Excel is a good fit—and when to use another tool
Excel is practical when a project has a manageable number of tasks, a small group of editors, and a schedule that benefits from a familiar grid. It is flexible for adding notes, owners, filters, and custom views. A workbook can also be useful for a static status report when the audience needs a simple picture of planned dates rather than live workflow management.
Excel becomes less convenient when many people edit at once, dependencies regularly change, or a project needs automatic notifications, workload balancing, approval flows, or a shared authoritative schedule. A dedicated project-management tool may handle those requirements more directly. A calendar may be better for appointments and events, while a spreadsheet timeline is better for comparing task durations across a date range. Choose based on how the plan is updated and used, not just on how quickly the first version can be made.
Frequently Asked Questions
Does Excel have a project timeline template?
Excel includes workbook templates that may provide a starting point, though available templates can vary. A custom grid like the example gives control over the task columns, date scale, and formatting. You can also search Excel’s template screen for project-planning or Gantt-style templates and adapt one to your scheduling conventions.
Can Excel automatically move dependent tasks?
The conditional-formatting timeline in this example does not automatically reschedule dependent tasks. It colors dates based on the dates entered in each row. To calculate linked dates, you would need to build explicit dependency logic or use project-planning software designed to manage task relationships.
How do I show weekends in an Excel timeline?
Use consecutive dates across the header, including Saturday and Sunday, rather than a WORKDAY sequence. The bars will then show calendar-day spans. If tasks should be counted only on working days while weekends remain visible, clearly distinguish the display scale from the duration calculation.
Can I make the timeline weekly instead of daily?
Yes. Use one column per week and label each column with a consistent week-start or week-ending date. Decide how a task that starts or ends midweek should be represented, then apply the same convention to every row. Weekly columns save space but show less exact timing than daily columns.
Will the timeline update when I change a task date?
Yes, the conditional-formatting bar updates when a task’s start or finish date changes, provided the dates remain within the displayed header range. The header itself updates if its formula inputs change, but manually entered task dates do not shift just because another task moves.
Related
- Customer Details in Excel: How to Set Up a Useful List
- Customizable Calendar Template in Excel: How to Make One
- Email Merge from Excel: Steps, Setup, and Safer Sending
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- How to Create Labels in WordTo create labels in Word, open Mailings > Labels, choose the label brand and product number that match…
- Excel: Highlight the Bottom 10 Values in RedTo highlight the 10 lowest values in red in Excel, select the cells containing your numbers, then choose…
- Outlook Email Scheduling: How to Send Messages LaterTo schedule an email in Outlook, write the message, open the menu beside Send, choose Schedule send, and…
- Find and Replace in Excel: Select Data FirstTo find and replace text in only part of an Excel worksheet, select the cells or range first,…
- Python pandas Excel Formatting: A Practical Guide to StylesTo format an Excel file created with pandas, write the data with DataFrame.to_excel(), then apply styles with pandas…
- Proper Excel Data Entry: Rules, Tips, and Common ErrorsProper Excel data entry means arranging information consistently, keeping one value in each cell, choosing the right data…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.