Others

How to Set Remaining Duration to Reach a Target Date in MS Project

Emma Brown Sep 30, 2026 868 views

Question details

The user wants to know how to calculate or set the remaining duration so that a task reaches a specific target finish date in Microsoft Project.

How to Set Remaining Duration to Reach a Target Date in Microsoft Project

Product: Microsoft Project
Device & OS: not provided
Scenario: Tracking project progress and calculating the exact remaining duration required to meet a fixed target finish date.
Observed behavior: Microsoft Project normally calculates dates based on inputted duration or work, rather than automatically calculating the duration based on a fixed target date.

Before you start

Ensure you have established your project calendar and working hours, as Microsoft Project relies on these settings to accurately calculate working days between dates.

Solution 1Recommended

Update Actual Work and Remaining Work

Track work values instead of just duration to let Microsoft Project automatically calculate the adjusted finish date.

Microsoft Project normally uses duration or work as inputs to calculate finish dates. For more accurate project tracking, it is recommended to update the actual work completed and the remaining work instead of manually forcing the duration to change.

Open task views

Open your project schedule in Microsoft Project and switch to a task view, such as the Task Usage or Tracking Gantt view.

Insert work columns

Right-click on the column headers and insert the 'Actual Work' and 'Remaining Work' columns if they are not already visible.

Enter work values

Enter the actual hours worked and the estimated remaining hours required to complete the task. Project will automatically adjust the duration and finish dates based on these inputs.

Solution 2

Use the ProjDateDiff Formula in Custom Fields

Calculate the exact working-day duration between a task's start date and a fixed target date using a custom formula.

Free Microsoft Office alternative

Track Project Schedules Free with WPS Spreadsheet

While Microsoft Project is powerful, it can be overly complex and expensive for everyday task tracking. WPS Office offers a free, lightweight alternative with WPS Spreadsheet, which includes built-in Gantt chart templates and standard Excel date formulas to easily track your project duration, work, and target dates.

1. Download WPS Office: Install WPS Office for free on your PC or Mac from the official website.
2. Open WPS Spreadsheet: Launch the application and open a new blank spreadsheet or your existing project tracker file.
3. Apply a Project Template: Navigate to the template library and search for 'Project Tracker' or 'Gantt Chart' to instantly set up automated date and duration calculations.

100% Free and lightweight Office suiteSeamless compatibility with Microsoft Excel (.xlsx) formatsRich library of free Gantt chart and project tracking templatesFamiliar tabbed interface for easy, intuitive task management

microsoft office alternative - wps office

Frequently Asked Questions

Why does Microsoft Project change my finish date when I change duration?

By default, Microsoft Project calculates the finish date by adding the duration to the start date based on your active project calendar. If you manually change the duration, the finish date will automatically shift to reflect the new calculated timeline.

How does the ProjDateDiff function work?

The ProjDateDiff function calculates the number of working minutes or days between two specified dates, strictly taking into account the working times, weekends, and non-working holidays defined in a specific project calendar.

Is it better to track duration or work in MS Project?

It is generally better to track 'Work' (actual work and remaining work). Estimating the effort (work) required provides a more accurate reflection of real project progress, allowing MS Project to automatically calculate realistic durations and resulting finish dates.

Office Quick Solutions