I'm hoping someone can provide me with a formula that will calculate a daily interest amount with a changing daily balance? The goal is to get rid of the daily tracking spreadsheet for each loan so I can keep several loans on one spreadsheet. I put together a simple spreadsheet that shows what I'm trying to accomplish.
Bookmarks