Adaptive forecasting based on variable project lengths

Glenn

Very grateful for your efforts. I did think that even for advanced excel users, this might me a tricky one so I am VERY grateful for the help received - thank you.

Have attached again though (sorry!), just another query...

If I put the start date early in a particular month, I would expect there to be a significant percentage of the available days in the "days on project" bit (as there are more days in the month available to work if you start earlier), but it appears to give the opposite - giving the number of days passed in that month, rather than the number of days left to work. This only happens for the first month, for the last month, this approach is what is needed.

Hope that makes sense, attachment explains a bit better.

Scott