filtering resp. today()

M

m b

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Filter and Delete all rows with a date greater than or = today 0
advanced filter date criteria 1
Programm Auto filter for overdue time 0
Need a little help with a custom function 1
Delete rows autofilter range problem 5
Advanced filter 10
Unable to delete rows for only filtered results 6
copy data when Autofilter On and active 0

Top