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
Bookmarks