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.

Hello All,

I have tried to no avail to get this to work.

See Attached Book30.xlsx

The only way I knew to do it was to add 2 columns. Column D is supposed to tally how many days late. column E is supposed to divide column D by 5. And column F will multiply column E by $5.

I can't get my formula to work in column D2 in order to calculate total days late. I am trying to get it to tell me how many days late the deliverable is if there is not a date entered in column C. FYI - our system generates 1/1/1900 as a value so I have to use this as a baseline.

I am getting a negative value in Column D5.

Any help is greatly appreciated!

:'( can anyone let me know what I am doing wrong?

But what if C:C has a value of 1/1/1900?

Our Database will return the value of 1/1/1900 if the delivered date is not yet actual. I still need a way to do a formula that if = 0 or 1/1/1900 change the value to "Today" and then do the subtraction from the Due date to find out the 5 day increments.