If every 5 days late . . .

Hey guys,

I cannot find help with this anywhere so please pardon me if it has been mentioned previously.

I am trying to create a formula that will allow me do see what my penalty would be for being late with submitting my deliverable.

See Attached Book30.xlsx

Here is the following criteria that I need to be met:

If the Site ID has a completion date, but does not have a deliverable complete day within 5 days of the complete date, a penalty of $5 must be tallied up for every 5 days the deliverable is delinquent.

So for Site PID01, the Penalty would continue to calculate until there was a Deliverable Complete Date.

For PID011, there would be a penalty value that is relative to how many times they were 5 days late between 10/2/2014 and 2/10/2015.

Let me know if you need clarification.