L lastevens Aug 26, 2004 #1 Is there any way to set up a formula to add interest to overdue accounts?
J JE McGimpsey Aug 26, 2004 #2 Sure, but there are myriad ways to do that. one way: Assume amount in A2, due date in B2, periodic interest rate in J1. Further assume that interest is due after 30 days, and accrues each 30 days... =ROUND(A2*(1+$J$1)^INT((TODAY()-B2-1)/30),2)
Sure, but there are myriad ways to do that. one way: Assume amount in A2, due date in B2, periodic interest rate in J1. Further assume that interest is due after 30 days, and accrues each 30 days... =ROUND(A2*(1+$J$1)^INT((TODAY()-B2-1)/30),2)
