View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
manfareed manfareed is offline
external usenet poster
 
Posts: 94
Default Problem filtering by data 12/01/2002

Hi ,

I have data in 13 columns and the second column contains the "start dates".
The "start dates" are in the following format "26/09/2007" etc. [UK Date
format].
I need to filter for dates greater than "12/01/2002". So far I have been
unsuccessful. I have tried to reformat the "start date" column as date and as
text but I still cannot filter for "greater than" via the autofilter.
"12/01/2002" is not an actual date in the " start date" column.

I don't mind if I have to use a macro to get the required result.

Thanks