View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
72malibu 72malibu is offline
external usenet poster
 
Posts: 4
Default Scheduling with Work Week m-f

I have put together a schedule, so that every column has a formula to where
each column adds 1 day to the previous. It all works well, until I have a
Saturday and Sunday. I have a 30 column spreadsheet and when I enter the
starting date, I want the days to change with the formula, except I need it
to skip Sat and Sun. I know I can do it individually, cell by cell, but that
just takes forever.
Is there any formula I can enter that will make this schedule not count
Saturdays and Sundays?