Essentially what I’m trying to do is find a formula that generates the same values I’ve typed into the “Formula?” column in the second table below.

More specifically, I know how to write a lookup where (thattable, column1, =thisrow.X) returns all rows matching thisrow’s X. And I know how to write contains formulas. But I want to combine them, to return all rows where “All days between” contains “Date”. Or happy to consider another way to do a similar thing.

Thanks!