View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ken Proj mgr
 
Posts: n/a
Default How do I set up a calculation to exclude weekends?

Hello,
I am using Excel to schedule construction processes for homes. It is set up
by columns. Example "Column B..Row 2" gets the actual date typed in and I
set up calculations to add days to the schedule. For instance: Column B..Row
3 would be Row 2 +1. I want to have Saturday and Sunday automatically add
2 days to the calculation. I would need the new dates to carry forward. Is
this possible?