How do I calculate On Time %

[tsgray1026]

I need to calculate on time delivery percentages - PO Delivery Date vs Actual posting date for a range of dates - I have the No of Days difference for the rows - 2 -2174; I have tried a couple of formulas recommended here, not working out. I not a expert at Excel, any suggestions would be appreciated.

 

[Krayna]

Can you be more specific - what is defined as on time?

 

[tsgray1026]

Can you be more specific - what is defined as on time?

On time would be the "PO Delivery Date" - the actual delivery date is the "Posting Date". "Days Difference" is how many days late or early the materials arrived.

 

[etaf]

how many days are you allowing as ontime ? 1,2,3,4,5????

On time would be the "PO Delivery Date"

Compared to what
I can post a letter today 1st class and expect it to be delivered tomorrow ( assuming not a sunday and so ONTIME would be days greater than 1
using something like networkdays.intl() to exclude sunday and holidays

PO Delivery Date vs Actual posting date for a range of dates

What would be the allowed number of days
then you could use a countif() > then the number of days
divided by the count of all the cells
to get a % missed
OR
then you could use a countif() < = then the number of days
to get a % met