Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old January 11th 05, 07:57 PM
dpl7579
 
Posts: n/a
Default Formating Dates for production schedule

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  
Old January 11th 05, 08:43 PM
Dave O
 
Posts: n/a
Default

If you include a column that represents duration in days for each
aspect of the project, subsequent dates after the start date could
simply be a formula. The date for each task in the project could be
the date for the previous task plus the number of days for the current
task.

For instance: suppose column A is your task description, column B is
the duration in days, and column C is the due date for the current
task. Suppose the entry in A1 is "Start Date" and the entry in C1 is
1/17/2005 (from your example). The next task, in A2, is "Send first
round layouts", the duration in B2 is 4, and the formula in cell C2 is
=WORKDAY(C1+B2,D110)
.... where D110 is a list of holidays. The WORKDAY() function returns
the date of a weekday that is the number of days (specified in B2)
after a startdate (C1).

By linking each tasks due date to the prior tasks due date, your
schedule becomes dynamic. If a date slips then you can either hardcode
the date or adjust the number of days for that task to match, and
subsequent dates will adjust.



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
Ploting dates against a calendar and not as a simple events Barb Reinhardt Charts and Charting in Excel 2 January 22nd 05 02:41 AM
Entering dates in Excel 2002 DickG Excel Discussion (Misc queries) 3 January 9th 05 02:56 PM
I get wrong dates when i paste from a different sheet into a new s mmollat Excel Discussion (Misc queries) 2 January 6th 05 07:35 PM
Filtering with dates T Excel Discussion (Misc queries) 1 December 29th 04 07:01 PM
Can I get email alerts when dates in excel are nearing? lucrecat Excel Discussion (Misc queries) 2 December 14th 04 05:14 AM


All times are GMT +1. The time now is 02:19 AM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017