First, calculate future value, as in:
=fv(10%/2,(2007-2005)*2,0,-1000)
=1215.15

Therefore, interest is $215.15

Regards,
Fred.

"manas123" wrote in message
...
Help me please,

I want to calculate interest accured between two dates
data i have
start date (1st jan 2005)
End date or maturity date (1st jan 2007)
amount invested( $1000)
interest rate 10% per annum
Componuded semiannualy
how can we calculate witouht any fractional error if we follow 30/360 day
counting covention .