Formulas involving dates
 

I am trying to set up a calculator to show the current balance of my student
loans. I figured out how to show today's date, but that's as far as I could
get. I have posted and example of what I am trying to do he
http://farm1.static.flickr.com/152/3...7174c5b9_o.jpg
I need formulas for the last three columns on the right and the bottom row.
The information is hypothetical. Don't go thinking I'm posting my financial
info online.

Thanks for the help.

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.