Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
dpl7579
 
Posts: n/a
Default how do i make a date change automatically if i change one before .

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.
  #2   Report Post  
Abi
 
Posts: n/a
Default

Do you have a specific time period in which to do everything? I mean, If
your flow is StartReviewApproveShip (as an example) do you have a set
number of days that are required between each, as in:

Start to Review - 10 days
Review to Approve - 10 days
Approve to Ship - 10 days

Or, is there no set schedule, (or at the very least, a policy-driven
schedule!)

Abi

"dpl7579" wrote:

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.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Help: Can I change the date formula from mm/dd/yyyy to "mmm-yy" et wintersunshine Excel Discussion (Misc queries) 7 July 5th 05 09:44 PM
Excel: How do I enter a date in one cell & automatically dates adj Shannon Excel Discussion (Misc queries) 4 January 12th 05 01:51 AM
How would I change a date cell to decrease it by business days? CNGracin Excel Discussion (Misc queries) 3 December 15th 04 06:20 PM
How do you change the date to a Number help me Excel Discussion (Misc queries) 8 December 15th 04 08:54 AM
prevent 4/5 in a cell automatically transfer to a date format kei Excel Discussion (Misc queries) 3 December 9th 04 12:52 PM


All times are GMT +1. The time now is 10:28 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"