I have a worksheet where column A holds dates todays date would be the
below yesterdays and so on) and coumn B holds a percentage. On a
separate page, I have an average field that is currently displaying a
fixed average of 90 days from the other sheet. I would like a formula
so the number of days can be input and then it would return the average
for the last x days. I have tried numerous forulas but it seems that
average cannot have a formula result as the arguments.

Any help is much appreciated.