Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I have a production schedule within an excel document. I have a start date
and a release date. Between these dates I have different dates that represent deliverys, approvals and review dates. These dates are sometimes changed due to weather, client issues, etc. Everytime I have to change a date, I have to look at a calendar and make the changes in each cell after the first change. Is there a way to format all the cells after the first start date, so if I change one date, all dates after that will change the same amount of days, leaving out weekends and national holidays. Take into consideration that the dates listed are not in order. I.e. (Start Date 1/17, send 1st round layouts 1/21, get client approval 1/24, etc) Any help would be appriciated. Cheers. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Help: Can I change the date formula from mm/dd/yyyy to "mmm-yy" et | Excel Discussion (Misc queries) | |||
Excel: How do I enter a date in one cell & automatically dates adj | Excel Discussion (Misc queries) | |||
How would I change a date cell to decrease it by business days? | Excel Discussion (Misc queries) | |||
How do you change the date to a Number | Excel Discussion (Misc queries) | |||
prevent 4/5 in a cell automatically transfer to a date format | Excel Discussion (Misc queries) |