Spreadsheet: 800107d1665491235-select-range-an-easier-way-to-implement-formula-over-different-ranges-example
Sheet: Sheet1

Returns | Date |  |  | Output examples
0.049 | 2022-10-10 00:00:00 |  |  |  | 2022-10-11 00:00:00
-0.003 | 2022-10-10 00:00:00 |  |  | Manual date (11/10/22) selection | Automatic date selection
-0.024 | 2022-10-10 00:00:00 |  |  | [NAME]
-0.037 | 2022-10-10 00:00:00
-0.015 | 2022-10-10 00:00:00 |  |  | Average Return
0.022 | 2022-10-11 00:00:00
-0.035 | 2022-10-11 00:00:00
0.015 | 2022-10-11 00:00:00
0.027 | 2022-10-11 00:00:00 |  |  | [NAME]
0.074 | 2022-10-11 00:00:00
0.019 | 2022-10-11 00:00:00 |  |  | Average Return
0.015 | 2022-10-11 00:00:00
-0.072 | 2022-10-11 00:00:00
0.039 | 2022-10-11 00:00:00
0.032 | 2022-10-11 00:00:00 |  |  | [NAME]
0.082 | 2022-10-11 00:00:00
-0.038 | 2022-10-11 00:00:00 |  |  | Average Return
-0.053 | 2022-10-11 00:00:00
0.006 | 2022-10-11 00:00:00
0.019 | 2022-10-11 00:00:00
0.093 | 2022-10-12 00:00:00
-0.077 | 2022-10-12 00:00:00
0.033 | 2022-10-12 00:00:00
-0.055 | 2022-10-12 00:00:00
-0.079 | 2022-10-12 00:00:00
0.083 | 2022-10-12 00:00:00
0.07 | 2022-10-12 00:00:00
-0.033 | 2022-10-12 00:00:00
-0.048 | 2022-10-12 00:00:00
0.088 | 2022-10-12 00:00:00
-0.085 | 2022-10-12 00:00:00
0.096 | 2022-10-12 00:00:00
-0.056 | 2022-10-12 00:00:00
-0.071 | 2022-10-12 00:00:00
0.055 | 2022-10-12 00:00:00
0.072 | 2022-10-12 00:00:00
-0.054 | 2022-10-12 00:00:00
-0.094 | 2022-10-12 00:00:00
-0.045 | 2022-10-12 00:00:00
0.065 | 2022-10-12 00:00:00
-0.006 | 2022-10-12 00:00:00
0.02 | 2022-10-12 00:00:00
-0.028 | 2022-10-12 00:00:00
-0.067 | 2022-10-12 00:00:00
0.005 | 2022-10-12 00:00:00
-0.093 | 2022-10-12 00:00:00
-0.052 | 2022-10-12 00:00:00
-0.081 | 2022-10-12 00:00:00
0.079 | 2022-10-12 00:00:00
-0.062 | 2022-10-12 00:00:00
0.038 | 2022-10-12 00:00:00
-0.017 | 2022-10-12 00:00:00
0.05 | 2022-10-12 00:00:00
0.069 | 2022-10-12 00:00:00
0.064 | 2022-10-12 00:00:00
-0.004 | 2022-10-12 00:00:00
0.029 | 2022-10-12 00:00:00
-0.022 | 2022-10-12 00:00:00
-0.057 | 2022-10-12 00:00:00
0.099 | 2022-10-12 00:00:00
0.05 | 2022-10-12 00:00:00
0.082 | 2022-10-12 00:00:00
0.054 | 2022-10-12 00:00:00
0.077 | 2022-10-12 00:00:00
0.056 | 2022-10-12 00:00:00
-0.082 | 2022-10-12 00:00:00
0.028 | 2022-10-12 00:00:00
0.097 | 2022-10-12 00:00:00
-0.002 | 2022-10-12 00:00:00
0.09 | 2022-10-12 00:00:00
-0.076 | 2022-10-12 00:00:00
-0.049 | 2022-10-12 00:00:00
0.082 | 2022-10-12 00:00:00
0.012 | 2022-10-12 00:00:00
0.021 | 2022-10-12 00:00:00
-0.007 | 2022-10-12 00:00:00
0.05 | 2022-10-12 00:00:00
-0.079 | 2022-10-12 00:00:00
-0.01 | 2022-10-12 00:00:00
0.048 | 2022-10-12 00:00:00
-0.039 | 2022-10-12 00:00:00
0.063 | 2022-10-12 00:00:00
-0.014 | 2022-10-12 00:00:00
0.012 | 2022-10-12 00:00:00
0.018 | 2022-10-12 00:00:00
0.083 | 2022-10-12 00:00:00
-0.036 | 2022-10-12 00:00:00
-0.041 | 2022-10-12 00:00:00
-0.029 | 2022-10-12 00:00:00
-0.021 | 2022-10-12 00:00:00
-0.08 | 2022-10-12 00:00:00
0.067 | 2022-10-12 00:00:00
0.05 | 2022-10-12 00:00:00
0.013 | 2022-10-12 00:00:00
-0.021 | 2022-10-12 00:00:00
0.049 | 2022-10-12 00:00:00
0.039 | 2022-10-12 00:00:00
0.07 | 2022-10-12 00:00:00
0.071 | 2022-10-12 00:00:00
0.09 | 2022-10-12 00:00:00
-0.025 | 2022-10-12 00:00:00
-0.059 | 2022-10-12 00:00:00
-0.028 | 2022-10-12 00:00:00
-0.013 | 2022-10-12 00:00:00
-0.075 | 2022-10-12 00:00:00
-0.085 | 2022-10-13 00:00:00
-0.072 | 2022-10-13 00:00:00
0.046 | 2022-10-13 00:00:00
-0.08 | 2022-10-13 00:00:00