none
How to calculate the Expected finish date in MS Project RRS feed

  • Question

  • TASK NAME  BASELINE START BASELINE FINISH  ACTUAL START   ACTUAL FINISH   EXPECTED COMPLETION
    1. Initial      01-Aug-2016        05-Aug-2016         01-Aug-2016      05-Aug-2016      NA
    2. Task -2   08-Aug-2016        10-Aug-2016         08-Aug-2016      12-Aug-2016      NA
    3. Task -3   11-Aug-2016        12-Aug-2016             NA                    NA                 16-Aug-2016
    4. Task -4   15-Aug-2016       17-Aug-2016              NA                    NA                19-Aug-2016
    5. Final       18-Aug-2016       19-Aug-2016             NA                     NA                23-Aug-2016

    Task-2 exceeded 2 days, so final task is expected to complete on 23-Aug-2016.
    How to calculate in MS Project ?

    Friday, August 26, 2016 1:48 AM

All replies

  • Hi,

    First of all, when you create your project plan, you have to add dependencies between tasks (ie links). As you can see below I created your tasks with dependencies so the expected finish date (finish column) is automatically calculated. Before setting progress on the tasks, there is no actual dates.

    Then when you set the initial task to 100%, actual dates are filled. In your case, task 2 has a 2 days delay, so you can increase the duration to 5 days and set it complete. Actual dates will be filled as required and Project automatically calculates the expected finish date as 23/08/2016 in the finish column.

    Finally you can use the format tab to visualize the expected plan against the baseline.


    Hope this helps,


    Guillaume Rouyre, MBA, MVP, P-Seller

    Friday, August 26, 2016 7:12 AM
    Moderator
  • You still have to manually update remaining task durations as if all tasks done by that person, contractor, team are taking longer to do that predicted you have to manually increase the durations of all their remaining tasks to get a more realistic finish.

    To calculate based on past performance is going into the realm of Earned Schedule which is a new scheduling tool that unfortunately Project does not support. (See www.earnedschedule.com)

    But as Guillaume said, you need tasks linked at the very least.


    Rod Gill
    Author of the one and only <a href="http://www.project-systems.co.nz/project-vba-book/index.html"> Project VBA Book</a><a> and VBA developer.</a><a href="http://www.project-systems.co.nz/">www.project-systems.co.nz</a></p>


    Monday, August 29, 2016 11:38 PM
    Moderator