Hi

It is very helpful if somebody can help me out with some simple formula for the examples given in the attached sample works sheet.
What i am trying to find out is,
1. Overdue/(Advance Days)=Due date - Collection Date (Column I in the attached works sheet)
2. Overdue Amount (Column J)
3. Penalty Amount. = 0.10 per thousand Per day of overdue(Column L).

In the attached excel sheet,In cell L5 penalty amount calculated is 599.03 which is wrong. It has to be 524.15. The reason for the error is, I have already calculated the penalty amount for 1 day in cell L4. hence in cell L5 it needs to be calculated only for 7 days(I.e, 8-1). I am unable to find a formula for that. Since the no of entries very large it is not practical to do it manually.

Thanks in advance
Overdue Penalty.xlsx