I have following values:
(1) Loan agr. start date (col. A)
(2) Loan agr. end date (col. B)
(3) Loan amount (col. C)
And I have to find the amount of balance outstanding as at particular date.
Example:
1. 08/11/2013 - 08/13/2013 3500 USD
2. 08/12/2013 - 08/15/2013 5000 USD
3. 08/14/2013 - 08/15/2013 1000 USD
So, in 08/13/2013 the balance outstanding was 8500 USD. Could anyone help with formulas?
(1) Loan agr. start date (col. A)
(2) Loan agr. end date (col. B)
(3) Loan amount (col. C)
And I have to find the amount of balance outstanding as at particular date.
Example:
1. 08/11/2013 - 08/13/2013 3500 USD
2. 08/12/2013 - 08/15/2013 5000 USD
3. 08/14/2013 - 08/15/2013 1000 USD
So, in 08/13/2013 the balance outstanding was 8500 USD. Could anyone help with formulas?