I need to calculate the interest rates for a period of time
I do have couple of years to calculate and thousands of entries, Please see the logic and let me know what function should I use to calculate dayes between a range.
A B C Interest Rate
Period A Jan 1st to Feb 10 5%
Period B Feb 11 to Feb 14th 8%
Payment 1> Obligation Paid Date : Jan 1st, Actual Paid Date : Feb 12
What I need to calcluate is the following
for Payment 1 I have 31+10 days Overdue in Period A and 2 Days in Period 2.....
This thread is now locked and can not be replied to.