Advanced filter a dynamic date range

O

oneandoneis2

I need to use an advanced filter to find entries for a particular rang
of dates. Trouble is, the ranges vary (predicatably) on a daily basis.

It's easy to set up a filter to return "all values between THIS dat
and THAT date", but what I *need* is one that will return "all value
between the date in THIS cell and the date in THAT cell"

Sadly, just putting in ">=B2" doesn't make the filter look for date
greater than or equal to the date in cell B2.

Any suggestions?

Thanks
 
Top