Formula to Dynamically Pick Values Based on a Date Range

[cpbrehmer]

Hi Everyone,

New to designer and need help building a formula that will work as an Analytic App where the Interface is a Date Selector. I've currently set the Input Data to contain unique records in each row, and each column has a different value to be used in the formula. Each Value Column is a different Date.

Where the Date Selector comes in is that I would like users to be able to pick a date range and the formula would dynamically use each day within the date range in chronological order.

Example of the Formula:
((([Day 1]+1)*([Day 2]+1)*([Day 3]+1)*([Day 4]+1)*([Day 5]+1)*([Day 6]+1)*([Day 7]+1))-1)*100

In the above example I am only using 7 of the days in the formula, but I would like the user to be able to select any of the days available in the Source input, and the formula would use the selected Start and End Date and all days in between in order. The number of records in the Source Input could change as well.