M

#### manas123

I am trying to find an easy / short way to calculate future value of a lump

sum amount between two dates.

The info I will have :-

1. Amount (say $1000 )

2. Start date of deposit (1st jan 2008)

3. Date to which future value is to be calculated to (1st may 2010)

4. Interest rate ( fixed 10%)

5. Compounded semiannualy.

How can I create a formulae to calculate this in one swoop ?