Hi,
I have data arranged with dates in column A and associated values in column B.
Can someone please suggest a formula to compound the values in column B between two dates (specified in C1 and D1) by amending the following function:
{=(PRODUCT(1+B1:B30/100)-1)*100}
Thanks!
Bookmarks