Hello,

I need help figuring out a formula that counts the number of incomplete jobs
for a specific worker that are within the next seven days. I would only want
to count the "Date Completed" column if it was blank and within seven days
from today's date. I've tried using sumproduct, but I can't seem to figure
out how to get the date calculations to work properly.

My data looks similar to this

Worker Due Date Date Completed
Bob 1/18/2010 1/13/2010
Bob 1/21/2010
Bob 2/20/2010
Tom 1/20/2010
Tom 2/10/2010 1/10/2010

You help is much appreciated.