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)
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
