Selecting a date range within a row report

Hi folks,

I have a large row report collecting data from over 6k sheets with some columns. Two columns define a start and end date.

The time period can be rather long - several years, actually.

I'm looking for a way to select rows inside this large period of time. Something like "show me all rows where the start date is in the past and does not end in the next 30 days."

I've found no option to do some calculations in the filtering section, so the second part of the condition is the difficult one.

Is it possible to do this?

Thanks in advance.

Best Answer