ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Could really use some help with this macro. (https://www.excelbanter.com/excel-programming/313398-could-really-use-some-help-macro.html)

sungen99[_12_]

Could really use some help with this macro.
 

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

--
sungen9
-----------------------------------------------------------------------
sungen99's Profile: http://www.excelforum.com/member.php...nfo&userid=914
View this thread: http://www.excelforum.com/showthread.php?threadid=26855


Bob Phillips[_6_]

Could really use some help with this macro.
 

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





All times are GMT +1. The time now is 08:00 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com