Question: how to calculate interest between two dates in excel?
Answer:  subtract the earlier date from (1+ the later date) to get the # of days. at that interest rate.
 divide the number of days by the # of days in the year.
 multiply the result by the interest rate times the principal amount.
 sum your results.