MS Project Backward scheduling

Posted on 2014-07-11
Last Modified: 2014-07-17
I am in need of backward scheduling part of a MS Project ganntt.  Let me try to explain what I have.

1. Envision if you will a set of tasks say Task 1 through 5 with a start and end date.
          a. Note this end date will move around based on delays and such

2. This end date is now what I need to schedule the remainder of my tasks, (say Task 6 through 10) to finish on that date based on the duration of each task that is assigned to it so I can know the latest date I can start the task to finish by above end date.

I hope this is clear and easy to do but ATM I am having trouble making this work

Thank you in advance for any help
Question by:Blackbeltrrf
    LVL 47

    Accepted Solution

    Try some As Late As Possible (ALAP) tasks, then in subsequent phase the standard ASAP tasks, with appropriate dependencies.
    some ALAP some ASAPsome-alaps.msp.xml
    LVL 12

    Expert Comment


    if I get this right you have a calculated finish date from the first five tasks and want to make sure that another set of Tasks doesn't run later that this date. Right?
    Then I would enter the calculated date from the first set of tasks and enter this as "Due Date" (existing standard field in Microsoft Project, add to your table on the left side of the view) for the other tasks. This leads to something very similar as backward calculation as it calculates the buffer (and hence the "critical" attribute) for each task against this date. To make it more dynamic you can copy the "Finish" date of the first set of tasks  and "Paste Special" -> "Link" to the "Due date". This will always update the "Due date" automatically when the finish date changes.

    SHOWING the early or late date in a Gantt is just based on the definition of the "Gantt Chart" but I guess you need a way of CALCULATING it correctly.

    Hope this helps


    Author Closing Comment

    Thank you to all who offered their help.  I was able to work it out with your help.

    Featured Post

    Maximize Your Threat Intelligence Reporting

    Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

    Join & Write a Comment

    Re-planning is just as important as planning. MS Project files need to be updated regularly to reflect the current status of the project and to streamline the upcoming tasks. We have seen a lot of issues where project managers have not updated the p…
    Online collaboration is quickly becoming embedded in the workplace, and its benefits are tangible. See what the current landscape looks like and what the future holds for collaboration tools and the future of work.
    Internet Business Fax to Email Made Easy - With eFax Corporate (, you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
    In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…

    746 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    13 Experts available now in Live!

    Get 1:1 Help Now