Others

Display Elapsed Task Days in Microsoft Project

Huda QurayshiHuda Qurayshi Nov 14, 2026 868 views

Question details

Display the number of calendar days or working days elapsed since a task started.

Display Elapsed Task Days in Microsoft Project
Product
Microsoft Project
Device & OS
not provided
Scenario
A user wants a task field that compares the task start date with the current date.
Observed behavior
The desired field should show elapsed time without changing the task's scheduled Duration.
Before you start

Check that the task has a valid Start date and decide whether to count calendar days or working time. For working time, review the project calendar and its hours per day.

Solution 1Recommended

Show elapsed calendar days in a custom Number field

Use this method to count calendar date boundaries since the task started, including weekends and holidays.

This custom field reports elapsed days separately from the scheduled Duration field. It can show a negative value for a future start date and continues counting after a task finishes.

1
Open custom fields

In Microsoft Project, open the Project tab and select Custom Fields.

2
Choose a task field

Select Task, choose Number as the field type, and select an unused field such as Number1. Use Rename if you want a descriptive label.

3
Add the formula

Select Formula and enter DateDiff("d",[Start],Now()). Confirm the formula and close the Custom Fields dialog.

4
Display the result

In a task table, right-click a column heading, select Insert Column, and choose the custom Number field. Press F9 to recalculate the project when needed.

Show elapsed calendar days in a custom Number field
Free Microsoft Office alternative

Track elapsed task dates in WPS Spreadsheets

WPS Office is a free, lightweight alternative for spreadsheet-based task tracking. Its familiar interface and Excel format compatibility make it easy to move existing spreadsheet trackers into WPS. It does not change Microsoft Project custom fields.

Track task start dates and elapsed calendar days in a spreadsheetOpen and edit Microsoft Excel XLSX filesUse a familiar spreadsheet interface for an easy transitionWork with a free, lightweight office suite
microsoft office alternative - wps office

Frequently Asked Questions

Does the elapsed-days formula change the task's Duration?

No. A formula in a custom Number field displays a separate result. The Duration field remains part of the task's schedule.

Does DateDiff include weekends and holidays?

DateDiff("d",[Start],Now()) counts calendar date boundaries, so weekends and holidays are included. Use a calendar-aware calculation such as ProjDateDiff for working time.

Why does the elapsed value continue increasing after a task finishes?

The formula compares Start with Now(), not with Finish. It therefore continues counting until you change the formula or remove it.

Why is the working-day result fractional?

ProjDateDiff measures working minutes. Dividing those minutes by the standard minutes per day can produce a partial day, depending on the start time and current time.

How can I refresh a formula that uses the current date?

Press F9 in Microsoft Project to recalculate the project and update the custom field.