| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| What does "resp" mean? | Excel Discussion (Misc queries) | |||
| IF TODAY equals date in cell A10, or if TODAY is beyond that date | Excel Worksheet Functions | |||
| trouble filtering a list. Why isn't column filtering? | Excel Worksheet Functions | |||
|
=IF(OR(TODAY() |
Excel Discussion (Misc queries) | |||
| VBA - Today() not available in VBA? | Excel Programming | |||
Linear Mode
