Hello guys,

I have been searching for something suitable for my case but i failed to find. So i need help.

I created a document where i will calculate supplier delivery performance score.

I enter 2 dates as due date and delivery date and the difference between dates are shown as day format.

For ex. 11 days difference. I calculated the score simple as =100-(differance*10)

But this formula doesn't work good always. The score exceeds above 100 or below 0. I would like the outcome to be in between 0 and 100.

What would you recommend for scoring formula?

Thank you.

P.S. Sorry i am at work now, system didn't let me upload files to forum. I will upload if needed in the evening.