I am amazed at how many ways there are to do this. Thank you for responding,
Fred. I will print all these. Connie

"Fred Smith" wrote:

One option is to create the column without weekends, using a formula like:
=if(weekday(a1)5,a1+3,a1+1)
Copy down

Regards,
Fred

"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

.