Exclude Weekends
Hi,
date in a1 days to add in B1
=A1+B1-CHOOSE(WEEKDAY(A1+B1,2),0,0,0,0,0,1,-1)
Mike
"JJ" wrote:
Hi Mike
if the start date is Saterday then return to Friday. If Sunday, return to
Monday.
JJ
"Mike H" wrote:
JJ,
What day would you want to return if the calculated start date was a Sunday?
Mike
"JJ" wrote:
How do I set up the calander to exclude weekends in my schedule calculation?
Est Start Date 04/01/2010
Leadtime = 5 days
Actual start date is 09/01/2010 which is a Saterday.
It would be great to change the act start dte to 08/01/2010 Friday.
Tx.
|