View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Fred Smith[_4_] Fred Smith[_4_] is offline
external usenet poster
 
Posts: 2,389
Default Date list excluding weekends

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