| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date Formulas
Thank you! I'll try that!
"bj" wrote: 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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| date formulas | Excel Discussion (Misc queries) | |||
| Still needs help with date formulas | Excel Discussion (Misc queries) | |||
| Date Formulas | Excel Worksheet Functions | |||
| Date formulas | Excel Discussion (Misc queries) | |||
| Using formulas to determine date in one cell based on date in anot | Excel Worksheet Functions | |||
Hybrid Mode
