I have a 'Start Date' and an 'End Date' Column, which contain a data range on one sheet. And I have a table on another sheet which contains a 'Date' column and a 'Value' column.
I would like to calculate the average value for the period between the 'Start Date' and an 'End Date'
For example...