Date Calculations

[Carla Goodloe]

We'd like to be able to plug in a date and have multiple
dates throughout the sheet change either up or down
depending on the # of days changed with the plug. For
instance, on 5/6/04 we have millwork in a home...If that
date changes due to delay, we want the future painting,
plumbing, tile, grout, etc. to also change by the same #
of days that the millwork changed. Is that possible?
What type of formula/functions do I need here?

 

[Rob van Gelder]

More than likely you would store the following:

Millwork date
Millwork delay (days)
Plumbing Date
Tile Date
Grout Date
etc..

Then some formulas:
Est. Plumbing Date: =Plumbing Date + Millwork delay
Est. Tile Date: =Tile Date + Millwork delay
Est. Grout Date: =Grout Date + Millwork delay
etc..