Project Timeline Excel Template: Simple Planning Guide

How-to basics · Updated November 20, 2026

Yes. A simple project timeline Excel template can be a single worksheet with tasks, owners, start and finish dates, status, and a calendar grid that highlights when each task is scheduled. In Microsoft Excel for Microsoft 365 on Windows, you can create one with ordinary cells and conditional formatting, without a special add-in or complex formulas.

What a simple project timeline includes

A timeline is a visual schedule: it shows when work is planned to happen and how tasks relate to the project’s overall dates. It is not necessarily a full project-management system. A useful starter sheet makes it easy to answer three questions: What needs doing? Who is responsible? When is it due?

Use one row per task and include a small set of columns before the calendar:

  • Task: A clear action or deliverable, such as Draft survey or Review launch copy.
  • Owner: The person or team accountable for moving it forward.
  • Start: The planned first day of the task.
  • Finish: The planned last day. Decide whether dates are inclusive and apply that convention consistently.
  • Duration: Optional, but helpful for checking whether the dates make sense.
  • Status or percent complete: A brief indicator of progress, separate from the planned dates.

Across the right side of the sheet, add date columns. Colored cells in that grid form the timeline bars. A milestone, such as approval or delivery, can be represented by a one-day task or a distinct symbol and label. The simplest version does not need dependencies, resource calculations, or automated schedule changes.

Choose a timeline scale that fits

Before building the calendar, decide whether readers need to plan by day, week, or month. Daily columns work for a short project with date-specific work. Weekly columns are easier to scan for a project lasting several months, while monthly columns suit a high-level roadmap. A calendar with too many tiny columns may technically contain more detail but can be difficult to read on screen or print.

For example, a two-week website update might have daily columns, with tasks such as content review, design changes, testing, and release. A six-month office move is more likely to need weekly or monthly columns, with major phases and decision dates. Choose a scale that helps someone make a decision, rather than one that simply fills the worksheet.

Also distinguish a calendar-day plan from a working-day plan. A task scheduled from Friday through Monday spans four calendar dates but may involve only two ordinary working days. State whether weekends are included, and consider local holidays where they affect the schedule. A basic calendar grid can display dates regardless of whether anyone is expected to work on them.

Build the worksheet in Excel

Start a blank workbook and enter the column headings in row 1: Task, Owner, Start, Finish, Duration, Status, and % Complete. Add a sample task in row 2, then leave enough rows for the project’s work. Keep the task names specific; Prepare materials is more useful than Admin, for example, because a reader can tell what is expected.

  1. Enter task names and owners in columns A and B, and planned dates in columns C and D. Format the date columns as dates using Home > Number Format.
  2. In column E, calculate calendar-day duration if it will help review the schedule. With a task’s start date in C2 and finish date in D2, enter =D2-C2+1 in E2. If the task starts on March 3 and finishes on March 7, the inclusive result is 5 days.
  3. Enter a status such as Not started, In progress, or Done, and enter completion as a percentage if the team can estimate it consistently. Format the completion cells as Percentage.
  4. Convert the task list to an Excel table with Insert > Table, or Home > Format as Table. A table makes the list easier to filter and helps formatting extend when rows are added. The calendar grid can remain outside the table.

The duration formula counts calendar dates inclusively, not working days. It returns a negative value if the finish date is earlier than the start date, which is a useful sign that the dates need review. If you do not need duration, leave that column out rather than adding a calculation that users might misunderstand.

Add dates and Gantt-style bars

To create a simple Gantt-style view, put the first calendar date in H1 and subsequent dates in I1, J1, and the cells to the right. Format the headings as dates. One way to fill the next date is to enter =H1+1 in I1 and copy it right; if H1 contains April 1, I1 displays April 2. For a weekly view, enter the first date of each week and advance by seven days instead.

To shade the cells between each task’s start and finish, select the calendar area for the task rows, such as H2:AZ30. Choose Home > Conditional Formatting > New Rule, then choose the rule type that uses a formula to determine which cells to format. With dates in C and D, task rows beginning at row 2, and calendar dates in row 1, use this formula:

With task start dates in C2:C30, finish dates in D2:D30, and calendar headings in H1:AZ1, enter =AND(H$1>=$C2,H$1<=$D2) as the conditional-formatting formula for H2:AZ30. Choose a fill color and confirm the rule. For a task running April 2 through April 4, the cells under those three dates will be shaded. The dollar signs keep the header row and start/finish columns fixed appropriately as Excel evaluates other cells.

Make sure the selected range begins at H2 if the formula refers to H$1 and row 2. If your calendar starts elsewhere, adjust the cell references to match the top-left cell of the range. When a bar does not appear, check that the task dates and calendar headings are real Excel dates rather than text that only looks like dates. A date cell can be tested by changing its number format; a real date displays as a serial number when formatted as General.

Keep progress separate from the plan

A planned bar shows the scheduled period; it does not prove that work is underway or finished. Keep status or percent complete in a separate column, and agree on what those values mean. For instance, a team might define In progress as work started but not accepted, and Done as the deliverable reviewed and accepted. Without shared definitions, progress figures can look precise while meaning different things to different people.

Excel’s Home > Conditional Formatting > Data Bars can display percentages visually in the completion column. Data bars are a quick visual aid, not a substitute for clear status labels or a conversation about blockers. If a task is delayed, update its dates only after the project owner decides on a revised plan; otherwise the sheet can conceal the difference between the original commitment and the current forecast. Keeping a dated copy or recording a baseline separately can help when that distinction matters.

Make the template readable and maintainable

A timeline is useful only if people can interpret it and keep it current. Freeze the task headings and task-name columns so they remain visible while scrolling: select the cell below and to the right of the rows and columns to keep visible, then choose View > Freeze Panes > Freeze Panes. For example, selecting H2 before using the command keeps row 1 and columns A through G visible. On Excel for Mac, the Freeze Panes control is also on the View tab, though ribbon layout can vary by release.

Use a small, consistent color scheme. One color for scheduled work, a different style for milestones, and a neutral shade for weekends can be enough. Add a legend if colors carry meaning, and do not rely on color alone: status text should still communicate the task’s state. Avoid merged cells in the task list, because they can interfere with sorting and filtering.

  • Use filters to focus on one owner, phase, or status at a time.
  • Set practical column widths and wrap long task names so they are not cut off.
  • Use a clear date format, such as 3-Apr, and include the year somewhere visible if the plan crosses year-end.
  • Check the print preview and set a landscape page orientation if the calendar is wide; use print scaling cautiously because shrinking a large grid can make text unreadable.

Common problems and simple fixes

Bars are missing or misplaced. Confirm that the conditional-formatting rule covers the intended grid, that its formula uses the correct start and finish columns, and that dates are genuine date values. Also check for a finish date earlier than the start date. A rule can be correct but applied to the wrong range.

The timeline is too wide. Switch from daily to weekly columns, or limit the displayed calendar to the project’s active period. A simple template should expose the information people need most often, not every possible date at once. You can keep detailed dates in the task list while showing weeks in the visual grid.

Updates overwrite the original plan. If stakeholders need to compare commitments with later forecasts, preserve baseline dates in separate columns or save a dated snapshot before revising the schedule. A single set of dates cannot show both the original plan and the latest plan at the same time.

Task bars imply dependencies that do not exist. Bars show timing, but do not automatically say that one task must finish before another begins. Add a predecessor column or a short note when sequence matters. In a basic worksheet, a dependency is informational unless someone actively checks it after changing dates.

When Excel is enough—and when it is not

Excel is a reasonable choice for a small project, a personal plan, or a shared schedule where a few people can coordinate edits. It is flexible, familiar to many users, and makes it easy to customize columns and print a view. A simple workbook is especially effective when the project has a manageable number of tasks and one person is responsible for maintaining the schedule.

Consider a dedicated project-management tool when the plan needs automatic dependency scheduling, workload balancing across many teams, notifications, audit history, or live collaboration controls that the workbook does not provide. Excel files can be shared through OneDrive or SharePoint, but simultaneous editing and access depend on how the workbook is stored, users’ permissions, and compatible Excel versions. A spreadsheet does not become a complete project-management system simply because it contains colored bars.

Another alternative is a calendar application for appointment-driven work, or a task-list tool for a collection of independent to-dos. Choose based on what must be coordinated: dates and phases favor a timeline, while reminders, conversations, or recurring assignments may be better handled elsewhere. It is also possible to use Excel for the high-level schedule and a separate tool for detailed work, provided one source is clearly identified as authoritative.

Frequently Asked Questions

Does Excel have a project timeline template?
Excel for Microsoft 365 on Windows offers templates through File > New, where you can search available templates. What appears can depend on the installed version and connected template services. You can also create a basic timeline in a blank workbook using task rows, date columns, and conditional formatting.

How do I make a project timeline in Excel?
List tasks, owners, start dates, and finish dates in columns, then create date headings across the sheet. Apply a conditional-formatting formula to shade calendar cells that fall between each task’s start and finish. Add status and completion information separately so the schedule is not mistaken for a progress report.

Can I make a Gantt chart in Excel without a template?
Yes. A date grid with conditional formatting can act as a simple Gantt-style chart. It is often easier to customize than a chart when you need a compact schedule, though it will not automatically manage dependencies or reschedule related tasks.

Should I use days or weeks for the timeline?
Use days when the work is short or dates matter at daily resolution. Use weeks for longer projects where daily columns would make the view too wide. For an executive overview spanning many months, monthly columns may be clearer, with exact dates retained in the task table.

How do I show a milestone?
Give it a one-day date and label it clearly, or use a distinct marker in the calendar grid with a legend. A milestone represents a significant event or decision, not a period of work, so a long bar can give the wrong impression.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.