View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
manas123 manas123 is offline
external usenet poster
 
Posts: 3
Default HOW CAN WE CALCULATE INTEREST ACCURED BETWEEN TWODATES

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 .