Posted to microsoft.public.excel.programming

m b

external usenet poster

Posts: 1

filtering resp. today()

hi,
i have an excel-sheet that should filter out all rows with date after
today. if i define the filter criteria as "is greater or equal than" and
"today()" all rows will be hidden. if i type in the date myself it will
work. strange behavior. what's the difference between today() as a
function and as manually typed data???
is there any idea how to filter out all rows automatically?
thy in advance
michael

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
What does "resp" mean?	Elise148	Excel Discussion (Misc queries)	2	July 2nd 07 03:30 PM
IF TODAY equals date in cell A10, or if TODAY is beyond that date	SoupNazi	Excel Worksheet Functions	4	April 23rd 07 01:14 AM
trouble filtering a list. Why isn't column filtering?	Pat	Excel Worksheet Functions	1	July 18th 05 03:30 PM
=IF(OR(TODAY()G9),"Pass","Overdue") Why doe it not wo.	Fkor	Excel Discussion (Misc queries)	3	March 10th 05 08:29 AM
VBA - Today() not available in VBA?	Byrt Martinez	Excel Programming	1	January 30th 04 02:38 AM

All times are GMT +1. The time now is 11:05 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us