Use TODAY() not NOW(), the latter includes time


--

HTH

RP

"sungen99" wrote in message
...

How do I filter for todays date? It seems that I only can choose from a
list and the custom option does not allow me to enter a =now() type
command. Or am I looking at doing this the wrong way?


--
sungen99
------------------------------------------------------------------------
sungen99's Profile:
http://www.excelforum.com/member.php...fo&userid=9144
View this thread: http://www.excelforum.com/showthread...hreadid=268553