Percentage of dates that are 7 days late

[RobertK]

I'm trying to create a formula that will give me the Percent of Activities
with Actual Comp. Dtd. (column C) More than 7 Days after Recommended Comp.
Dtd. (column B). In the example there may be dates in column B and none in
column C these are to ignored. I have thousands of rows so I don't want to
add a formuls in another column that determines each one separatly and than
sum them up. I need to do it in one step.

A B C
Act 1 2/3/09 2/5/09
Act 2 6/7/09 7/6/09
Act 3 1/5/09 3/4/09
Act 4 4/3/09
8/9/09

Robert K

 

[T. Valko]

Maybe this:

=SUMPRODUCT(--(C2:C100-B2:B100>7))/COUNT(C2:C100)

Format as Percentage

 

[RobertK]

Thanks, I may have another one for you but I like to exhaust all my
possibilites first.

 

[T. Valko]

We're always open!

Thanks for the feedback!