MegaSack DRAW - This year's winner is user - rgwb
We will be in touch
I’m looking to do a production schedule based on a known shipping date and want to aitomatically populate the cells prior to this shipping date with the relevant operation run time in days.
i.e. Shipping date is 24/02/2020
Testing Dates 10/02/2020 - 21/02/2020
Assembly 13/01/2020 - 07/02/2020
Paint 01/01/2020 - 10/01/2020
I do not want the weekend days to be taken into consideration for the schedule. The cells colour should represent each different operation. Also looking to have the ability to input the actual start date of Paint which will automatically update the operation days for each following process without altering the ship date. Thanks in advance for any help.
Not quite sure what you're tying to achieve with the cell colours, but I think you'll find the WORKDAY() function useful - it'll calculate the date N days before/after another day excluding weekdays and any days you've defined as holidays (eg bank holidays, Xmas shutdown etc)
What I should have said that the ship date should be highlighted yellow, test dates green, assembly dates blue, paint dates purple.
Imagine you'd want to just subtract whatever durations are in cells to the left of shipping date from the shipping date and format as date?
Would a project software product be preferable? *runs for cover*
Yes - I have a table with components and process times and want to populate a chart with the appropriate dates.
@mrsheen Yes it probably would but I would imagine excel could easily create what I’m looking for but my knowledge doesn’t move much beyond standard if statements and basic pivot tables.
OK, so you want to select a component and enter its target ship date, then have a table filled in with all of the relevant process dates with each process colour coded? Do all components have the same processes?
Will you be doing this for one component at a time or do you want to be able to have a list of components with all of the dates for each one?
Then you want to be able to amend the actual date of a process then have all the other dates update based on that, but without affecting the final delivery date?
OK, so you want to select a component and enter its target ship date, then have a table filled in with all of the relevant process dates with each process colour coded? Do all components have the same processes?
Yes - the components do have all the same processes but with different times for each process.
Will you be doing this for one component at a time or do you want to be able to have a list of components with all of the dates for each one?
I’d prefer to have a list of components with dates for each.
Then you want to be able to amend the actual date of a process then have all the other dates update based on that, but without affecting the final delivery date?
Yes.
Thanks.
If it's a table that you're filling in, then as I understand it each column will always represent the same operation, so you can simply colour that column. But if you want to display the dates on a calendar grid, and colour them appropriately, that's a different problem.
PM me your email address.
RM.