Excel Calculations

Copper Contributor



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


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


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.