Macro maybe?
Format the column as Special/ ddd, filter, custom, equals Saturday or equals
Sunday, delete rows.
"Connie Martin" wrote:
In Col. A there are dates, formatted as dates in the format of Sun - Jan 01,
2010 and it goes to the end of 2010. How do I delete all the Saturday and
Sunday's in one shot? Connie
|