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


"RobertK" wrote:

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