If you install EasyFilter you can do it very easy
http://www.rondebruin.nl/easyfilter.htm
If you want a macro solution or want to filter manual you must first insert a column
with a formula like this =C2 (c2 is the cell with the date) and format it like dddd (FormatCells.. Custom)
You can filter on this column and do a manual copy or use a macro from this page
http://www.rondebruin.nl/copy5.htm
--
Regards Ron de Bruin
http://www.rondebruin.nl
wrote in message ups.com...
I have a column with the date in it on the source spreadsheet..the date
format is DD-MMM-YY