I am working on creating a schedule manager at work. In the attached photo you should see the following:
Remaining P.O. Qty - 2556
Cycle time - 85 seconds
Total Days to complete = =(((((Remaining P.o. Qty* Cycle time)*0.8)/60)/60)/9)
Start Dates = Monday march 20, 2017
End Date = =ROUNDUP(Days to complete,0)+Start Date
I need the end date to exclude weekends. So shown in the photo is Sunday march 26, 2017
I need it to read Tuesday.
Thank you in advance for your assistance!
-Mike
Capture.JPG
Bookmarks