View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
manas123 manas123 is offline
external usenet poster
 
Posts: 3
Default calculation of future value between two dates


HELP please.

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 ?