Forum Discussion
Meeka475
Jul 01, 2024Copper Contributor
Excel Calculations
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!
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.