Formulas involving dates
Nevermind, I figured it out. I used the DAYS360 formula to get a number of
days, then used simple arithmetic formulas to figure out the interest
accrued and the current balance based on the number of days. It's not
perfect, but it gives a good rough estimate.
|