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


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com


"oneandoneis2"
wrote in message
news:oneandoneis2.25svco_1144255206.6271@excelforu m-nospam.com...

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!


--
oneandoneis2
------------------------------------------------------------------------
oneandoneis2's Profile: http://www.excelforum.com/member.php...o&userid=33195
View this thread: http://www.excelforum.com/showthread...hreadid=530129