software

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 quot;all values between THIS date
and THAT datequot;, but what I *need* is one that will return quot;all values
between the date in THIS cell and the date in THAT cellquot;

Sadly, just putting in quot;gt;=B2quot; 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: www.excelforum.com/member.php...oamp;userid=33195
View this thread: www.excelforum.com/showthread...hreadid=530129Use

=quot;gt;=quot;amp;B2--

Regards,

Peo Sjoblom

nwexcelsolutions.comquot;oneandoneis2quot; gt;
wrote in message
newsneandoneis2.25svco_1144255206.6271@excelforu m-nospam.com...
gt;
gt; I need to use an advanced filter to find entries for a particular range
gt; of dates. Trouble is, the ranges vary (predicatably) on a daily basis.
gt;
gt; It's easy to set up a filter to return quot;all values between THIS date
gt; and THAT datequot;, but what I *need* is one that will return quot;all values
gt; between the date in THIS cell and the date in THAT cellquot;
gt;
gt; Sadly, just putting in quot;gt;=B2quot; doesn't make the filter look for dates
gt; greater than or equal to the date in cell B2.
gt;
gt; Any suggestions?
gt;
gt; Thanks!
gt;
gt;
gt; --
gt; oneandoneis2
gt; ------------------------------------------------------------------------
gt; oneandoneis2's Profile:
gt; www.excelforum.com/member.php...oamp;userid=33195
gt; View this thread: www.excelforum.com/showthread...hreadid=530129
gt;

gt; Use
gt;
gt; =quot;gt;=quot;amp;B2

Excellent! Many thanks!--
oneandoneis2
------------------------------------------------------------------------
oneandoneis2's Profile: www.excelforum.com/member.php...oamp;userid=33195
View this thread: www.excelforum.com/showthread...hreadid=530129