View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
oneandoneis2
 
Posts: n/a
Default 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!


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