Selecting a date range within a row report

p_p_ing

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.

Paul Newcome

Your filter would look something like the below. The filter that is hidden is "is not in the last (days)".

Paul Newcome

Your filter would look something like the below. The filter that is hidden is "is not in the last (days)".

p_p_ing

Thanks a lot!

The "is not in the future" part escaped me somehow or my sequence of conditions was not correct.

Paul Newcome

Happy to help. 👍️