using autofilter custom function....filter of cells containing date...

  • Thread starter Thread starter jerry1480
  • Start date Start date
J

jerry1480

Autofilter function....

when i use custom in autofilter......to filter date e.g.
(2/30/2003)....the cells format is in date format.....as i filter by
using * and ?.....it can't be filter....but if i change the date to
text format...it can be filter.....so can anyone help me...to solve
this problem....is there any ways to filter the date in date
format....the file is attached ...thank alot....."P....


+----------------------------------------------------------------+
| Attachment filename: project costs monitoring(date).xls |
|Download attachment: http://www.excelforum.com/attachment.php?postid=344868|
+----------------------------------------------------------------+
 
You can't use wildcard characters to filter the dates, but you can use a
date range. In the Custom dialog box, choose:

'Is greater than or equal to' -- [enter your start date]
AND
'Is less than or equal to' -- [enter your end date]
 
In an empty column enter =TEXT(your date column,"dd/mm/yy"), and then
filter using this new column
Ilan
 
Back
Top