Hello!
I am new to the forum, but appreciate all the help this place provides!
I'm not entirely sure if this is the correct spot to post so if its wrong, please point me in the right direction.
What I am trying to do is calculate the interest we have to pay on an item when it starts accruing interest on a certain date. While doing this would be easy normally for me, this one has me stumped as the interest changes at the beginning of each month. I could use some help with the formula.
What I have:
- Amount Owed
- Date it starts accruing interest
- Rates each month
This is where I am at right now:
snip1.PNG
But I am trying to get this to calculate dynamically with many different start dates and so the next month can start calculating at a different rate.
I appreciate any insights on this!
Bookmarks