Array with all dates in between

This is something I want to try but haven’t yet. Currently I do a much more complicated process with VLOOKUPS in a google sheet to get a value that I can use to to build relations.

What you need is probably something a lot simpler. If you can set a start date value somewhere, then you can bring it into a table with a single value column. Then you can add a math column to add 7 days. Then you can use that single value column and math column in an IF column to compare to the date in each row. If it fits within the range, then return a value such as ‘true’. You can use that IF column value to set a filter on your list.