Forum Discussion

Meeka475's avatar
Meeka475
Copper Contributor
Jul 01, 2024

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!

  • 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.

Resources