Calculating percentage with 3 dates

[whiteprose]

In the Production Schedule worksheet, in the range A7:A14, enter formulas to calculate the percentage of each task that has been completed given the task’s start and stop dates and the current date in cell D5. (Hint: The percentage equals the number of days from the current date shown in cell D5 to the task’s start date in column C divided by the number of days allotted to complete each task.)
A B C D

Bronco Design
"Kinman Brothers Grocercy Store Website Task List"
		Today	4/17/2017
Status	Task	Start Date	Stop Date
	Collect content	4/3/2017	4/7/2017
	Menu interface and layout	4/6/2017	4/21/2017
	First draft	4/10/2017	4/18/2017
	Review and testing I	4/16/2017	4/20/2017
	Second draft	4/18/2017	4/27/2017
	Review and testing II	4/26/2017	5/4/2017
	Final draft	5/5/2017	5/10/2017
	Live Posting	5/10/2017	5/15/2017

 

[Marc L]

​

Cell A7 formula :​

​

=IF(D7<=$D$5,100,IF($D$5<C7,0,($D$5-C7+1)/(D7-C7+1)%))