Linking Returns
 

Date Return
1/31/04 2.0%
2/28/04 1.0%
3/31/04 3.0%
4/30/04 -2.5%
5/31/04 4.0%

I have a list of 5 years worth of monthly returns or 72 cells with dates and
the corresponding return. If I want to take a date range/period, I would
like it to link those returns. So in my example above if I type in 2/28/04 -
5/31/04 I would like excel to do the following
=((1%+1)*(3%+1)*(-2%+1)*(4%+1)-1)*100 which equals 5.486%. Can this be done
with excel? Thank you.