Software

Ask something
Discussion Locked

calculate interest between dates

0 helpful
1 reply

by arvindcfridhanbad

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

i like to know that how to calculat amount of interest between two dates in a exel worksheet when rate of interest varies with financial year i:e
from 1/4/2000 to 31/3/2001 rate is 10%
from 1/4/2001 to 31/3/2002 rate is 10%
from 1/4/2002 to 31/3/2003 rate is 10%
from 1/4/2003 to 31/3/2004 rate is 10%
from 1/4/2004 to 31/3/2005 rate is 10%
from 1/4/2005 to 31/3/2006 rate is 10%
i want to enter start date i;e 21/6/2000 & last date i;e 23/6/2005 & the amount 100 rest need formula to do.

1 reply

by chitosunday

if your from is cell b2:b7 and to c2:c7 and interest c2:c7 and input start is a11 and input end is b11 and principal amount is c11 then the formula is
{=SUM((((A2:A7<$B$11)*IF(B2:B7<$B$11,B2:B7,$B$11))-((B2:B7>$A$11)*IF(A2:A7>$A$11,A2:A7,$A$11)))*C2:C7*C11)}
Note: this is an array formula and you need first to input the formula without {} then after inputing but before enter you need to press ctrl shift enter

This discussion is closed to new replies.