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.