View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
John Krsulic[_2_] John Krsulic[_2_] is offline
external usenet poster
 
Posts: 6
Default Auto Fill days of the month (not including weekends)

I need to create a sheet where the days of the month show accross the top of
the columns. I have been starting with the first day of the month and auto
filling to the last day and then manually going in and deleting out the
weekends. Is there a way to create a formula where I can auto fill but not
have it include the weekends.

My heading should be July 2 July 3 July 4 July 5 July 6 July 9