Date Formulas

[Guest]

I am a construction superintendent, and I use an Excel spreadsheet to
organize my schedule. Sometimes my schedule changes and I need to change a
date in a column. This causes me to have to go through and change the rest
of the dates in the column as well. Is there a way to format the dates, so
they will automatically update when one date is changed?

 

[Guest]

you should be able to do so depending if there is a given relationship
between the dates. If you give an example of what you want to do, we can
robably help you. For example if one thing always happens 1 day after the
date in cell C3 using =c3+1 in the target cell date will show the day after
the date in C3.
With weekends and holidays it is a little more complex but still doable
depending on what you want to do

 

[Guest]

Yes, there is a way to do that.
..
..
..
Isn't it frustrating when people leave out the important part? Tell us how
you want the dates changed, and we can tell you how to do it. Please provide
an example so there is no confusion.

 

[Guest]

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!

 

[Guest]

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.

 

[Guest]

Thank you! I'll try that!

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.