Interest calculation
 

How do I calculate the interest on a princiapl balance from a date in the
past to today's date?

Interest calculation
 

missdivine828 wrote:
How do I calculate the interest on a princiapl balance from a
date in the past to today's date?

Compounded daily, I assume. If the principal is in A1, the deposit
date is in A2, and the annual interest rate is in A3, the current
balance is:

=fv(A3/365, today() - A1, 0, -A2)

The total accrued interest is simply that value less the principal,
namely:

=fv(A3/365, today() - A1, 0, -A2) - A2

Interest calculation
 

Have you subtracted the day in the past from today's date and used that
figure for your calculation? Don't forget that you may need to change your
cell formate to make this work.

"missdivine828" wrote:

How do I calculate the interest on a princiapl balance from a date in the
past to today's date?