tia for helping me with this.

I have 2 columns of dates "duedate" and "compdate"

I want to calculate the percentage of rows that met the due date based
on the last 4 weeks.

if n2:n20 < (today-28) and if n2:n20 < d2:d20 = met

(something that takes all the dates within the last 4 weeks and counts
how many are on or before the due date)

divided by

n2:n20 < (today-28) = total (the total number of compdates)

hope that was clear. In my efforts to try and solve this I'm thinking
something like

=sum (countif n2:n20, <today(-28), <d2:20) / (count n2:n20 <
today(-28))

again thanks


--
Cobra
------------------------------------------------------------------------
Cobra's Profile: http://www.excelforum.com/member.php...o&userid=31065
View this thread: http://www.excelforum.com/showthread...hreadid=507405