=MAX(0, D2 - A2) (Assuming D2 is payment date, A2 is due date. If no payment made, use today's date: =MAX(0, TODAY() - A2) )
For compound interest (if legally allowed and specified in contract), apply the formula iteratively per period (e.g., monthly). 4.1 Required Columns in Excel | A | B | C | D | E | F | |---|---|---|---|---|---| | Due Date | Principal (DKK) | Annual Rate (%) | Payment Date | Days Overdue | Interest (DKK) | 4.2 Formulas Days Overdue (Column E): renters rente formel excel
[ \textInterest = \textPrincipal \times \frac\textAnnual Interest Rate100 \times \frac\textNumber of Days Overdue365 ] =MAX(0, D2 - A2) (Assuming D2 is payment