check out the Workday function in help
if each stage in the project is based on the previous stage date, you can
change any of the dates and only the following dates will be changed
say you have three contractors which must work in sequence
C1:Scraping the lot, C2 applying weed killer, C3 laying asphalt
and each takes two workdays (OK it is a small lot)
in cell A1 enter the date you expect C1 to start
in A2 you could put the expected date for C2 to start as = workday(A1,2) and
for C3 in A3 =workday(A2,2)
now if C1 is late, it will automaticaly change the other dates

Note you must have the analysis toolpack loaded to use workday.


"Alyssa" wrote:

OK, hopefully I can explain this, so it will make sense...

Here's my example:
Let's say one of my contractors was scheduled to come on July 31, but he
can't make it until Aug. 2. This affects the rest of my schedule, and I will
have to postpone everything else on my schedule by 2 days. I've been having
to individually change each date. How can I make the dates change
automatically? The other challenge is I only schedule things on Mon. thru
Fri., so the dates need to change automatically (skipping the weekends).

I hope this makes sense!