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

[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|
+----------------------------------------------------------------+

 

[Debra Dalgleish]

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]

 

[Ilan Rencus]

In an empty column enter =TEXT(your date column,"dd/mm/yy"), and then
filter using this new column
Ilan