Hey everyone,

I need to make a scorecard to measure the service level provided by a supplier. e.g i should receive all the documents for a certain shipment 3 days prior to the expected time of arrival of a shipment. If the date entered in a cell is not 3 days before the arrival date, it should return a value of 0, else 1. Moreover, for all the shipments, it should measure a percentage depending on 0s and 1s in the calculations.

Thanks