Excel Calculations

Copper Contributor

Hello,

 

I need help creating benchmarks to measure my performance. Specifically, I want to calculate the percentage of assignments completed within three days. In one column, I have the "date of service," and in the next column, I have the "date the note was submitted." How can I determine the percentage of notes submitted within three days of the service date?

 

Thank you!

1 Reply

@Meeka475 

Let's say service dates are in D2 and down, and not submission dates in E2 and down. Formula:

=SUMPRODUCT((E2:E100<=D2:D100+3)*(E2:E30<>""))/COUNT(E2:E100)

Format the cell with the formula as a percentage.

It doesn't matter if some of the cells are still blank, but if the data extend below row 100, adjust the ranges in the formula.