Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date Formulas
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date Formulas
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 "Alyssa" wrote: 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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date Formulas
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. "Alyssa" wrote: 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? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date Formulas
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! |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date Formulas
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! |
#6
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 |