You can use EasyFilter if you want (very easy)
http://www.rondebruin.nl/easyfilter.htm



--
Regards Ron de Bruin
http://www.rondebruin.nl


wrote in message oups.com...
hi, could you please advise me how, using advance filter, to filter a
list of dates so Im left with fridays dates only. So far Ive tried,
dates in a3:a2893, Title DATES in a2, and my criteria in A1 which is
=weekday(5) or =weekday(date)=5. Im using USE date format mm/dd/yy. Im
not sure that I setting up the advance filter correctly. Any advice
appreciated,
Regards Robert