Notifications
Clear all
General Excel Questions & Answers
2
Posts
2
Users
0
Reactions
134
Views
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
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