Use the WEEKDAY formula to spot saturdays and sundays. Then use
filter/autofilter to hide them, copy visible cells to another location.

HTH. Best wishes Harald


"Connie Martin" wrote in message
...
If I have a column of dates (365 days) from Jan. 1 to Dec. 31, is there a
way
to delete all weekends without the long, manual way of doing it? Connie