Advanced filter a dynamic date range

I need to use an advanced filter to find entries for a particular range 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 date and THAT date", but what I *need* is one that will return "all values between the date in THIS cell and the date in THAT cell"

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

Any suggestions?

Thanks!

Use

=">="&B2


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com


"oneandoneis2" <[email protected]>
wrote in message
news:[email protected]...
>
> I need to use an advanced filter to find entries for a particular range
> 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 date
> and THAT date", but what I *need* is one that will return "all values
> between the date in THIS cell and the date in THAT cell"
>
> Sadly, just putting in ">=B2" doesn't make the filter look for dates
> greater than or equal to the date in cell B2.
>
> Any suggestions?
>
> Thanks!
>
>
> --
> oneandoneis2
> ------------------------------------------------------------------------
> oneandoneis2's Profile:
> http://www.excelforum.com/member.php...o&userid=33195
> View this thread: http://www.excelforum.com/showthread...hreadid=530129
>

> Use
>
> =">="&B2

Excellent! Many thanks!