Thread
:
How do I set up a calculation to exclude weekends?
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
Niek Otten
Posts: n/a
How do I set up a calculation to exclude weekends?
Look at the WORKDAY() function. HELP has the details; don't miss what it
says if you get a #NAME error
--
Kind regards,
Niek Otten
"Ken Proj mgr" <Ken Proj
wrote in message
...
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?
Reply With Quote