We have to run a weekly report with over 8000 lines, and there are many types of filter, it takes a while to filter different things.

Let's say I want to filter a report for the week of june 3rd.

So on Monday, i need to filter by date from may 22 8:00am to may 23, 7:59 am, tuesday will be like may 23 8am to to may 24 7:59am, wednesday will be something like may 24 8:00am to may 27 7:59am, because of the weekend...

I also need to use multiple filters, not just date and time. So one could be may 22 8:00 am to may 23 7:59 am, along with another filter for rush and non-rush as an exemple.

Date and time rush Banana Peter
5/24/2024 9:52
non-rush Apple Susan
5/28/2024 12:18
rush Peach Susan
5/30/2024 5:02
rush Banana Susan
5/23/2024 12:17
non-rush Apple Clark
5/28/2024 12:18
non-rush Apple Joey

So I need to do something like adding a filter between may 23rd 12:00pm to may 24 11:59am, then select rush, Banana and Peter. So I will have only one line (so the result is 1).

How would I do that automatically without using filters ? Maybe I can add a baseline date in one of the empty cells next to the report like June 3rd, then every Monday will be baseline date - 11 days. I can also add time in an empty cell like 8:00 am and 7:59 am. However, as far as the formula goes, I am stuck there. Also, the date and date (both date and time are in the same cell) column paste as a custom format.

I wonder what is the fastest and most efficient way to do it ?