Display Elapsed Task Days in Microsoft Project
Question details
Display the number of calendar days or working days elapsed since a task started.

- 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.
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.
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.
In Microsoft Project, open the Project tab and select Custom Fields.
Select Task, choose Number as the field type, and select an unused field such as Number1. Use Rename if you want a descriptive label.
Select Formula and enter DateDiff("d",[Start],Now()). Confirm the formula and close the Custom Fields dialog.
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.

Calculate elapsed working time using the project calendar
Use a calendar-aware formula when weekends and other nonworking time should be excluded.
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.

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.




