Thank you, Harald. I wish these formulas were more on the end of my fingers,
if you know what I mean. Shall print this so I don't forget it! Connie

"Harald Staff" wrote:

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

.