Forum

Notifications
Clear all

Calculate production flow dates

2 Posts
2 Users
0 Reactions
134 Views
(@dant)
Posts: 1
New Member
Topic starter
 

Hello,

I am trying to define a way to automatically calculate the start date (tab Timeline) of a production operation (WK09) knowing that the task length is 18 hours; however the number of available time to work on the operation varies according to the day of the week (see tab Work Center).

Please note I am not using Excel 365

 

Thank you so much

DanT

 
Posted : 13/04/2020 1:06 pm
(@catalinb)
Posts: 1937
Member Admin
 

Hi Dan,

There are still some things not very clear:

WK09 is a week number? If so, why you have the Start Date in week 9, when the end date 27/05/2020 is in week 22 ?

I assume you would manually input the end date and you want the start date to be determined?

 
Posted : 17/04/2020 2:52 am
Share: