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

filtering resp. today()
 

Hi
type in
=TODAY()

don't forget the equation sign

--
Regards
Frank Kabel
Frankfurt, Germany

"m b" schrieb im Newsbeitrag
...
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