How often is interest credited? Assuming every month, you want the FV
function:
=fv(5.5%/12,75,0,-1000)
=1409.12

This is the amount you will have in the bank at the end of the 75 months. Do
determine, the interest earned, subtract the original principal.

This doesn't account for the 20 days from 10 Jun 09 to 30 Jun 09. If you are
actually going to receive interest for this period, use the following:
=fv(5.5%/12,75,0,-1000)*(1+20/365*5.5%)-1000

Regards,
Fred.

"Karen" wrote in message
...
Need some help on a financial formula :

Let's say I have $1,000 in an account. The interest rate is 5.5%pa. If
start
date is 10 Mar 2003 and end date is 30 June 2009, interest is added on to
the
principal. How much interest will be generated at the end date?

What formula can I use?

Thanks.