Determine percentage of target based on two dates

Thank you both for your responses. I want the actual percentage number to appear, then I'll use conditional formating to highlight any numbers above or below the target. Per below, if I deliver on the same date I said I would deliver, then the number in the METRIC cell would be 1.00.

Target_______Complete_____Metric
03/31/2011___03/31/2011____1.00

Metrics
Marginal : metric less than .90
Review : metric between .90 - .93
Effective : metric between .94 - .97
Good : metric between .98 and 1.00
Outstanding : 1.00 plus 10% of commitments delivered ahead of schedule

I'm looking for a question in there somewhere...does the formula I provided do that for you?

Also, for the Outstanding status, it looks like it has to take into account all of the events, not just one. So the formula to determine whether you are Outstanding would have to use COUNT and COUNTIF to see if >10% of your metrics are >1.0.

I was able to resolve this problem by including the Start date. Sharing the solution fo anyone else who my come across this problem. I appreciate the assistance to get me here.

=IF(ISERROR(1-((NETWORKDAYS(L4,J4)-NETWORKDAYS(K4,J4))/NETWORKDAYS(K4,J4))),"",1-((NETWORKDAYS(L4,J4)-NETWORKDAYS(K4,J4))/NETWORKDAYS(K4,J4)))