View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Pete_UK
 
Posts: n/a
Default No Sat & Sundays

Enter your first date in A1 - ensure this is not a Saturday or Sunday.
In B1 enter this formula:

=IF(WEEKDAY(A1,2)=5,A1+3,A1+1)

Format this as a date, then copy across your columns.

Hope this helps.

Pete