How to Add Today’s Date to an Excel Gantt Chart [Guide]

Adding today’s date to an Excel Gantt chart sounds simple, yet many charts become confusing the moment the schedule moves forward. A fixed “today” marker quickly becomes yesterday’s status, while a manual highlight can hide delays and upcoming work. If your team checks the chart each morning, that small problem creates repeated maintenance and unreliable progress reviews.

But here’s the truth: Excel can update the current date automatically. You can show today’s date in a cell, highlight the matching timeline column, or create a clear vertical marker across the chart. The right method depends on how your Gantt chart is built and how visible you want the marker to be.

This guide walks you through each approach. You’ll learn the formulas, formatting steps, troubleshooting fixes, and a scalable alternative when a worksheet is no longer enough for project tracking.

Add Today’s Date to an Excel Gantt Chart

To add today’s date to an Excel Gantt chart, use =TODAY() in a helper cell, then apply conditional formatting to the timeline column that matches that date. This marker updates whenever Excel recalculates the worksheet.

The simplest setup uses three elements:

• A date row across the top of the Gantt chart.
• A cell containing =TODAY().
• Conditional formatting that identifies the matching date.

For example, assume your timeline dates run from cells F4:AJ4. Your task rows begin at row 5, and you want the current day to appear with a different fill color.

1. Click an unused cell, such as B1.
2. Enter =TODAY() and press Enter.
3. Format the cell as a date if Excel displays a number.
4. Select the Gantt timeline area, such as F5:AJ20.
5. Open Home > Conditional Formatting > New Rule.
6. Choose Use a formula to determine which cells to format.
7. Enter =F$4=$B$1.
8. Choose a noticeable fill color or border.
9. Click OK, then review the highlighted column.

The dollar signs matter. F$4 keeps the rule tied to the date row while allowing Excel to check each timeline column. $B$1 keeps the current-date cell fixed.

Use the TODAY Function

The TODAY() function returns the current date according to your computer’s date settings. It has no arguments, so the formula is simply:

=TODAY()

Because the formula updates during recalculation, you do not need to type a new date each morning. Pressing F9 forces a recalculation when you want to refresh the worksheet manually.

Keep in mind that TODAY() returns a date without a time. If you need the current date and time, Excel also offers =NOW(). A Gantt chart usually works better with TODAY() because daily planning does not require time-of-day precision.

Highlight the Current Timeline Column

If your Gantt chart displays calendar dates across row 4, use a conditional-formatting rule that compares each header date with the current date:

=F$4=TODAY()

Apply the rule to the entire chart range, such as F5:AJ20. Excel checks the date above each column and formats the cells underneath the matching day.

This approach removes the need for a separate helper cell. However, a helper cell can be easier to inspect when you are troubleshooting or sharing the worksheet with colleagues.

Show a Visible “Today” Label

A highlighted column shows where today falls, but it may not display a clear label. You can add one above the timeline with a formula such as:

="Today: "&TEXT(TODAY(),"mmm d, yyyy")

This produces a result such as Today: Mar 8, 2025. If your regional settings use another date style, replace the format with "dd/mm/yyyy" or another pattern you prefer.

You can also label the matching timeline header with a custom number format. Select the date headers, open Format Cells, choose Custom, and use a format such as:

ddd mmm d

The cell continues storing a real date, while the display becomes easier to read.

Prepare the Gantt Chart Before Adding the Marker

A current-date marker works only when Excel recognizes your timeline values as real dates. If the headers are text, a formula may appear correct while the highlight never activates.

Check Whether Timeline Headers Are Real Dates

Click a timeline header and change its format to General. A real Excel date usually becomes a serial number, such as 45624. You can then return it to a date format.

Another quick check is to use:

=ISNUMBER(F4)

If the result is TRUE, Excel treats the header as a numeric date. If the result is FALSE, the header may be text.

For example, typing March 8 with an apostrophe before it can store the value as text. A text header will not reliably match TODAY().

Create a Continuous Date Row

Your timeline should move forward one day at a time, or one week at a time if the chart uses weekly planning. For daily dates, enter the first date in F4 and use:

=F4+1

Drag the formula across the remaining columns. For weekly dates, use:

=F4+7

Keep the sequence continuous. A missing date can make the current-day highlight appear to skip a column.

Separate Dates from Task Bars

Many Gantt charts use colored cells to represent task duration. Keep the date headers in their own row and apply current-day formatting to the chart area below them.

For instance:

This layout makes the formulas easier to read and prevents a date rule from interfering with task names or milestone labels.

Three Practical Ways to Mark Today

You can choose a subtle date highlight, a vertical line, or a dedicated status label. Here’s why the choice matters: the best marker depends on whether your main goal is daily coordination, progress reporting, or presentation.

Method 1: Highlight the Matching Date Column

This is the easiest method for most worksheet Gantt charts.

1. Select the task area beneath the date row.
2. Open the conditional-formatting rule manager.
3. Create a formula rule using =F$4=TODAY().
4. Choose a light accent color.
5. Move the rule above competing rules if necessary.

Suppose your chart covers April 1 through April 30. On April 12, Excel checks each header. The column beneath April 12 receives the selected formatting, helping you compare planned work with the current day.

Use a pale color when task bars already have strong colors. A bright marker can overpower the chart and make completed work difficult to read.

Method 2: Use a Helper Row

A helper row can place a symbol under today’s date. In cell F3, enter:

=IF(F4=TODAY(),"Today","")

Copy the formula across the timeline. Only the matching column displays the word Today.

You can replace the label with a symbol:

=IF(F4=TODAY(),"▼","")

Apply a bold font and a contrasting color to the helper row. This technique is useful when you want a visible pointer without changing the task-bar colors.

Method 3: Add a Vertical Today Line to a Stacked Bar Chart

A chart-based Gantt layout can use a vertical line instead of a highlighted cell column. This method takes more setup but produces a cleaner presentation.

1. Add a helper value for each task that represents the current date.
2. Create a stacked bar chart containing task start, task duration, and current-date series.
3. Format the current-date series as a line or narrow marker.
4. Position it against the date axis.
5. Set the axis minimum and maximum to match the project timeline.

The exact steps depend on your chart design. A cell-based Gantt chart is usually easier to maintain, while a chart-based version can look better in a project review.

Build a More Reliable Conditional-Formatting Rule

Some Gantt charts need more than a simple equality check. You may want to shade the current day only when it falls inside a task’s planned range.

Highlight Active Work on Today’s Date

Assume start dates are in column B, end dates are in column C, and timeline dates begin in row 4. Select the chart range and use:

=AND(F$4>=$B5,F$4<=$C5,F$4=TODAY())

This rule highlights a cell only when three conditions are true:

• The timeline date is on or after the task start.
• The timeline date is on or before the task end.
• The timeline date equals today.

For example, a task running from May 10 through May 15 receives the current-day highlight only on the matching date. Empty schedule cells remain untouched.

Highlight Overdue Work

You can add a second rule for unfinished tasks that have passed their planned end date:

=AND($C5<TODAY(),$D5<>"Complete")

Here, column D contains the task status. Apply a red or amber format to the task row or the task-bar area.

Place the overdue rule carefully. If both rules apply to the same cell, Excel’s rule order determines which formatting appears. Use Manage Rules to move the most important condition higher.

Handle Blank Dates Safely

Blank start or end dates can create unexpected highlights. Add blank checks to the formula:

=AND($B5<>"",$C5<>"",F$4>=$B5,F$4<=$C5,F$4=TODAY())

This prevents unfinished rows from being treated as tasks beginning at Excel’s internal zero date.

Fix Common Problems with Today’s Marker

If the marker does not appear, the formula is usually correct but the surrounding worksheet setup is not. Check these areas in order.

The Current Date Is Outside the Timeline

A Gantt chart cannot highlight today if the displayed timeline ends before today or begins after it. If the project schedule covers June 1 through June 20 and today is June 25, no matching column exists.

Extend the date row or display a message such as:

=IF(AND(TODAY()>=MIN(F4:AJ4),TODAY()<=MAX(F4:AJ4)),"Today is visible","Today is outside the timeline")

The Worksheet Is Using Manual Calculation

Excel may not refresh TODAY() immediately when calculation mode is set to manual. Open Formulas > Calculation Options and choose Automatic.

You can also press F9 to recalculate. If the workbook contains many formulas, automatic calculation may take longer, so manual mode can be useful temporarily.

The Dates Include Time Values

A timeline cell containing March 8, 2025 08:00 will not equal TODAY(), even though both show March 8. Remove the time portion with:

=INT(A1)

Then use the cleaned result in the timeline. You can also compare only the integer portion:

=INT(F$4)=TODAY()

The Rule Starts in the Wrong Column

If the selected range begins at G5 but the formula refers to F$4, the formatting may shift by one column. The first column in the formula should match the first column in the selected range.

For a range beginning at F5, use F$4. For a range beginning at G5, use G$4.

Use an Excel Gantt Chart for Daily Project Reviews

Adding the current date is most useful when it supports a routine. During a daily review, compare the marker with task status, upcoming milestones, and work that has crossed its planned end date.

Imagine a website launch planned for July 18. On July 12, the marker sits over testing tasks. If testing is still incomplete, the team can adjust assignments before the launch date becomes risky.

The marker also improves weekly reporting. Instead of explaining where the project stands verbally, you can point to the current-day column and see completed, active, and upcoming work in one view.

Keep the Timeline Readable

Daily columns can make a long project difficult to view. Consider switching to weekly columns for a six-month schedule while keeping daily planning in a separate worksheet.

Use consistent visual meaning:

• Gray for completed work.
• Blue for planned work.
• Amber for attention needed.
• A narrow accent color for today.
• A diamond or bold symbol for milestones.

A legend prevents confusion when several people update the chart. Avoid using the same color for today and overdue tasks.

Protect Formula Cells

If several people edit the worksheet, protect the formula cells and leave task status areas unlocked. This reduces the chance that someone accidentally replaces =TODAY() with a fixed date.

Before protecting the worksheet, test the conditional-formatting rules. Protection settings can affect whether people can change formats or insert timeline columns.

Project Tracking Solution: ONES.com

Excel works well for a compact schedule, but a growing project often needs connected tasks, ownership, approvals, reporting, and history. ONES.com provides a unified platform for project management and knowledge management, with ONES Project serving as a Jira alternative.

Value Proposition

ONES.com helps teams move beyond manually maintained Gantt worksheets while keeping structured planning, reporting, and collaboration in one environment. ONES Project and ONES Wiki are sold separately, so you can choose the capability your team needs.

Core Capabilities

• Scattered task tracking: ONES Project centralizes work items, owners, priorities, and deadlines, giving the team one operational view.
• Manual schedule maintenance: Sprint management and planned dates help teams manage delivery periods without repeatedly rebuilding worksheet formulas.
• Rigid project fields: Custom fields let you capture release tags, risk levels, work types, or approval status in a consistent structure.
• Complex approval paths: Custom workflows route tasks through review, testing, approval, and completion stages, making ownership clearer.
• Limited reporting: Built-in reporting provides project visibility without requiring every status update to be assembled manually.
• Plugin-heavy processes: Jira-compatible workflows help teams familiar with Jira-style planning transfer established habits with fewer add-ons.
• Restricted deployment requirements: ONES.com supports Cloud, On-Premise, Private Cloud, and Air-gapped deployments.
• Feature differences between hosting models: ONES.com maintains full feature parity between its cloud and self-hosted versions.
• Separate knowledge and delivery work: ONES Wiki provides a knowledge base and serves as a Confluence alternative when project guidance needs a dedicated home.

Application Scenarios

Software release planning: A development team can manage sprints, defects, testing tasks, and release approvals in ONES Project. Instead of highlighting a daily worksheet column, the team reviews overdue work, current assignments, and sprint progress through project views and reports.

Regulated or restricted environments: A team that cannot use a public cloud can deploy ONES.com on-premise, in a private cloud, or in an air-gapped environment. The project structure remains available without forcing the team into a cloud-only setup.

Product and knowledge coordination: A product team can use ONES Project for delivery work and ONES Wiki for requirements, operating guidance, and team knowledge. Since the products are sold separately, the team can adopt either one or both.

Common Challenges When Adding Today’s Date

Challenge: The Marker Becomes Hard to See

Problem: Existing task colors overpower the current-day highlight.

Solution: Use a narrow border, a helper-row label, or a light vertical fill. Test the chart in both normal and print views.

Challenge: The Marker Stops at the Project End

Problem: Today moves beyond the final timeline column, so the marker disappears.

Solution: Extend the timeline automatically or add future columns before the project reaches the current date. A rolling timeline can use formulas that begin with a chosen start date and continue for a set number of periods.

Challenge: Weekend Dates Create Confusion

Problem: The current day may fall on a weekend, while the project schedule shows only business days.

Solution: Decide whether the chart should include weekends. If it excludes them, add a note when today is a nonworking day or use a business-day timeline generated with WORKDAY.

Challenge: Manual Updates Replace Dynamic Formulas

Problem: Someone types a fixed date over the TODAY() formula.

Solution: Put the formula in a clearly labeled helper cell, protect that cell, and explain its purpose in the chart legend.

FAQs About Showing Today in an Excel Gantt Chart

Does Excel update the current date automatically?

Yes. The =TODAY() function updates when Excel recalculates the worksheet, which commonly happens when you open or edit it. If the date does not refresh, check whether calculation mode is set to Automatic. You can also press F9 to force a recalculation. The result follows your computer’s date settings.

What formula highlights today’s column?

For a timeline beginning in column F with dates in row 4, use =F$4=TODAY() in a conditional-formatting rule. Apply the rule to the task area beneath the headers, such as F5:AJ20. Excel checks each column against the current date and formats the matching one. Make sure the headers contain real Excel dates rather than text.

Why does my current-date highlight appear one column too far left or right?

The first cell reference in the formula probably does not match the first column of the selected range. If the selected area begins at F5, start the formula with F$4. If it begins at G5, use G$4. Keep the row reference fixed with a dollar sign while allowing the column reference to move.

Can I show today as a vertical line instead of a colored column?

Yes. A cell-based chart can use a helper row with a symbol or label, while a stacked bar chart can use a separate current-date series. The bar-chart approach creates a more presentation-friendly vertical marker, but it requires careful axis settings and series formatting. For everyday planning, conditional formatting is usually quicker to maintain.

How can I highlight only active tasks on today’s date?

Use a formula that checks the task’s start date, end date, and the timeline header. If start dates are in column B, end dates are in column C, and the timeline begins in F4, use =AND(F$4>=$B5,F$4<=$C5,F$4=TODAY()). Add blank checks when unfinished rows may contain empty dates.

Conclusion

Adding today’s date to an Excel Gantt chart usually takes one formula and one conditional-formatting rule. Start with =TODAY(), confirm that your timeline headers are real dates, and highlight the matching column with a rule such as =F$4=TODAY().

But here’s the truth: the marker only helps when the schedule remains readable and current. Use clear colors, protect key formulas, handle weekends deliberately, and extend the timeline before today moves beyond it.

For a small plan, Excel may be enough. When your team needs connected workflows, sprint planning, reporting, custom fields, or restricted deployment options, ONES.com can provide a more structured project-management environment through ONES Project and related capabilities.