Excel Gantt Chart Start and End Dates Explained

In an Excel Gantt chart, each task’s start date sets the bar’s position on the timeline, and its end date determines when the bar finishes. For a standard stacked-bar chart, enter the start date and a duration; calculate an inclusive duration as end date minus start date plus one, then chart the start date as an invisible offset and the duration as the visible bar.

What start and end dates mean

A Gantt chart displays tasks against a shared time scale. A task’s start date is the first date its bar covers, while the end date is the last date it covers. Excel does not have a special built-in Gantt chart type: the usual approach repurposes a stacked bar chart so that a date value positions each task’s bar and a duration gives it length.

Decide how your project treats the end date before calculating durations. If a task starts on June 3 and finishes on June 5, an inclusive calendar-day duration is three days: June 3, 4, and 5. The formula is end date minus start date plus one. If your organization defines the end date as the moment work is complete and measures elapsed time between dates, it may use a different convention. Be consistent across the schedule, particularly when tasks begin or end on weekends.

A date-based Gantt chart also does not automatically represent working days, dependencies, or actual progress. It simply plots the values and series you provide. Those project rules need to be reflected in your schedule or added with separate columns and formatting.

Prepare the schedule table

For a simple chart, set up adjacent columns for Task, Start, and Duration. You can keep End in the next column for reference and checking. Enter genuine Excel dates—not date-like text—in the Start and End cells, and format them as dates using Home > Number. For example, a row might show “Design” starting June 3 and ending June 5, with a three-day duration.

With task names in A2:A10, start dates in B2:B10, and end dates in C2:C10, calculate inclusive calendar-day duration in D2 with =C2-B2+1. For the Design example, where B2 is June 3 and C2 is June 5, the result is 3. Copy the formula down the duration column. If the end date is earlier than the start date, the result will be zero or negative; check those rows rather than charting them.

If you prefer to enter a duration and calculate the end date, with a start date in B2 and an inclusive duration in D2, use =B2+D2-1 in C2. For a June 3 start and a duration of 3, the result is June 5. Format C2 as a date. Keep the “minus one” rule: a one-day task starting June 3 ends on June 3, not June 4.

For a basic chart, arrange the chart source as Task, Start, Duration, in that order, so the task labels and the two plotted series are easy to select together. You may place End after Duration. Check that Excel recognizes the start values as dates: changing a cell’s number format should change how a valid date appears, while text may remain unchanged.

Create the stacked bar chart

Select the Task, Start, and Duration columns, including their headers but excluding blank rows and any End column between the plotted series.
Choose Insert > Insert Column or Bar Chart > 2-D Bar > Stacked Bar. The chart initially displays both the Start and Duration series as colored segments.
Click a Start segment to select that series. Open Format Data Series and set its fill to No fill; set its line to No line if a border remains. The start values still position the Duration bars, but the offset segments become invisible.
Click the task axis, open Format Axis, and select Categories in reverse order if you want the first task at the top. Excel may move the value axis to the top after this change; adjust its axis-crossing option if needed.

The visible bars should now begin at their actual start dates and extend for the entered durations. If Excel places tasks or dates in the wrong chart roles, select the chart and use Chart Design > Select Data to review the series and category labels. The Start series should be the first stacked series and Duration the second; the task names should be the category labels.

Format the date timeline

The horizontal value axis uses Excel’s underlying date numbers. Dates in Excel are stored as serial values, so the chart can position a bar at a date even though the axis may initially display numbers or an unhelpful range. Right-click the horizontal axis and choose Format Axis. Under Number, choose a date format or enter a format such as mmm d; this changes the display, not the underlying dates.

Excel chooses axis bounds automatically, which is often adequate for a first draft. To focus the chart on a project window, set the horizontal axis Minimum and Maximum bounds to the serial values corresponding to the first and last dates you want shown. Excel date serials count days from a starting date, so do not type a calendar date as an arbitrary number. You can see a date’s serial by temporarily changing a worksheet date cell’s number format to General. If you set bounds manually, update them when the schedule moves outside that window.

Choose a major unit that suits the project: a few days for a short plan, or a week or month for a longer one. Axis units are measured in days for date serials, so a major unit of 7 produces roughly weekly intervals. The chart may not label every day when the range is long; that is normal. Use a date number format that stays readable at the chart’s size, and add a chart title or axis title if readers need the schedule’s date range explained.

Show end dates and milestones

The bar’s endpoint communicates the end date visually, but a reader may need the exact date printed beside each task. One straightforward method is to add a data label to the Duration series and use labels from cells, if that option is available in your Excel build: create a helper column containing the desired end-date labels, select the bars, and use Chart Design > Add Chart Element > Data Labels. In Format Data Labels, choose Value From Cells and select the helper range; clear the numeric Value option if you want only the date label. This feature is available in current Microsoft 365 desktop Excel, though the precise formatting pane can vary by update.

A milestone is usually a single point in time, not a task that lasts several days. You can represent it as a one-day task by using the same start and end date, then format that bar distinctly. For a more precise marker, add a separate data series and use an appropriate marker chart design, but that requires extra chart setup. Avoid entering a zero duration without checking how the chart renders it: a zero-length bar may be invisible.

Use a calendar grid instead

A stacked bar chart is compact and useful for presenting an overall schedule. A worksheet calendar grid can be easier when you want to shade individual date columns, print a daily plan, or add conditional formatting. Put task names in column A, start dates in B, end dates in C, and actual date headings across row 1 beginning in F1. Apply a fill color to the cells in the schedule area whose dates fall within each task’s range.

With task start dates in B2:B20, end dates in C2:C20, and real date headings in F1:AZ1, select F2:AZ20 and choose Home > Conditional Formatting > New Rule > Use a formula to determine which cells to format. Enter =AND($B2<=F$1,$C2>=F$1), choose a fill, and confirm. For each grid cell, the rule checks whether that column’s date is on or after the task start and on or before its end. The dollar signs keep the task date columns fixed while allowing the row and date heading to adjust across the selected range. If your schedule uses exclusive finish dates, revise the comparison to match that convention.

Common date and chart problems

Bars start at the wrong date: Confirm the Start series is included as the first stacked series and has no fill. A clustered bar chart will not create the same offset effect.
Dates show as large numbers: Format the horizontal axis as a date. The underlying values can be valid even when the number format is unsuitable.
Bars are one day too long: Check whether the project counts both the first and last date. For inclusive calendar days, use end minus start plus one.
Tasks are in reverse order: Change the category-axis order. Reversing categories can also alter where the date axis crosses, so check the axis position afterward.
Weekends appear in the bar: A calendar-day duration includes weekends. If the plan should show working days only, calculate and chart working-day durations separately; a simple start-plus-duration bar does not by itself skip nonworking dates on a continuous calendar axis.
A task disappears: Check for a zero or negative duration, text dates, a hidden series, or manually fixed axis bounds that exclude the task.

Also consider whether the task dates are estimates or committed dates. A bar can look precise even when its inputs are not. Add a note or a separate status column if readers need to distinguish planned dates from actual dates.

Choose the right Gantt approach

Use a stacked bar chart when you want a clean overview, relatively few formatting rules, and bars that can span a long project timeline. It works well for sharing a project snapshot, but it takes some chart formatting and is less convenient for shading weekends, displaying complex dependencies, or showing an exact label for every bar.

Choose a conditional-formatting grid when the schedule is short enough to show individual dates and readers benefit from a day-by-day or week-by-week view. It is flexible, but a long date range can make the worksheet very wide. For a detailed project plan with linked tasks, resource assignments, and automatic rescheduling, a dedicated project-management tool may be more suitable than a manually maintained Excel chart. Excel is most dependable when the workbook makes its date convention, source data, and update responsibility clear.

Frequently Asked Questions

How do I add start and end dates to an Excel Gantt chart?
Enter a start date and an end date in the schedule table, calculate the duration, then chart the start date and duration as stacked bars. Hide the Start series’ fill so it acts as an offset rather than a visible bar.

Should Gantt chart end dates be inclusive in Excel?
For a calendar-day plan where the end date is the final day of work, yes: calculate duration as end date minus start date plus one. Use a different calculation only if your project’s definition treats the finish date as an exclusive boundary.

Why does my Excel Gantt chart start at January 1900?
Excel may be displaying the date serial number as a plain number or using an unexpected automatic axis range. Format the horizontal axis with a date number format and check the Start values and axis bounds.

Can Excel automatically skip weekends in a Gantt chart?
Not in the basic stacked-bar setup. Its date axis is continuous, so weekends occupy space. A working-day schedule needs additional logic or a different layout; simply entering a working-day duration does not make the calendar axis omit weekends.

Can I show the exact end date on each bar?
Yes. Add a helper column with end-date labels and, in current Microsoft 365 desktop Excel, apply data labels using Value From Cells. Otherwise, keep the end dates visible in the adjacent schedule table.

Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.

More in Charts & pivot tables

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

Spotted an error in this guide? Let us know.