Could you utilize the Google sheets labs to make the date range dynamic?
Christian Snow
1

Hey Christian.

I think adding a date picker for start and end range is a good idea. For my purposes I’d probably set it up as another sheet for arbitrary date range queries, and retain the last week/last month/month-to-date on fixed ranges relative to today’s date.

What do you mean by “Google sheets labs”?