| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Auto Filter
II used an auto filter with a date column in Excel 2003. I tried to customize
it by having it select only dates before today. How can this be done, in auto filter. Thank you for your time. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Auto Filter
custom filter | choose is less than | type today's date and enter
On Dec 1, 11:08*pm, Mike Busch wrote: II used an auto filter with a date column in Excel 2003. I tried to customize it by having it select only dates before today. How can this be done, in auto filter. Thank you for your time. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Auto Filter
.... or if you want it to keep track of the current date, don't type in
today's date but instead type in =TODAY() -- David Biddulph "muddan madhu" wrote in message ... custom filter | choose is less than | type today's date and enter On Dec 1, 11:08 pm, Mike Busch wrote: II used an auto filter with a date column in Excel 2003. I tried to customize it by having it select only dates before today. How can this be done, in auto filter. Thank you for your time. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Auto Filter
Apologies. I was looking at conditional formatting, not autofilter. I'll
wake up later in the week. :-) -- David Biddulph "David Biddulph" <groups [at] biddulph.org.uk wrote in message ... ... or if you want it to keep track of the current date, don't type in today's date but instead type in =TODAY() -- David Biddulph "muddan madhu" wrote in message ... custom filter | choose is less than | type today's date and enter On Dec 1, 11:08 pm, Mike Busch wrote: II used an auto filter with a date column in Excel 2003. I tried to customize it by having it select only dates before today. How can this be done, in auto filter. Thank you for your time. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Auto Filter
Hi,
In all fairness =TODAY() in the Custom box with less than selected should work, however, it won't. Also, unfortunately, you can't reference a cell in the spreadsheet. So you are stuck with hard coding the current date. Cheers, Shane Devenshire "Mike Busch" wrote: II used an auto filter with a date column in Excel 2003. I tried to customize it by having it select only dates before today. How can this be done, in auto filter. Thank you for your time. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel auto-filter does not filter certain columns | Excel Discussion (Misc queries) | |||
| DataFilterAuto Filter in excel 2007? | New Users to Excel | |||
| Excel 2007 Auto Filter Filter | Excel Discussion (Misc queries) | |||
| Limit filter options in Auto Filter | Excel Discussion (Misc queries) | |||
| Excel auto filter doesn't recoginize case - won't filter AA from A | Excel Discussion (Misc queries) | |||
![Mike Busch[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
