Calculation of a percent completion based upon due date

I need to calculate the daily percent completion starting with 75% on May 9, 2012 with a 100% completion date of July 15, 2012. I need to know daily at what percentage the completion should be to meet the July 15 100% completion. Can someone please tell me the formula I should use to determine the daily percentage goal?

Hi,

Add the amount completed (75%) to the the result of dividing the number of days (67) to the due date by the target (100%) less the amount already completed (75%).

In B3 use =B2+(100%-$B$2)/67 and copy down to the end date.
HTH

Steve

Thanks Steve - perfect!