Jul 16 2021 02:39 PM
Hi,
In my production sheet, I would like auto calculate end date and time based on start date/time, total required hours, excluding weekend and holiday, and based on working hours from calender table:
Machine | Total required time (hours) | start date | End Date |
A | 56 | 7/17/21 10:35 AM | ? |
B | 46 | 8/17/21 11:34 | ? |
Calendar table
Date | Day | Working Hour |
17/07/2021 | Sat | 8 |
18/07/2021 | Sun | 8 |
19/07/2021 | Mon | 8 |
20/07/2021 | Tue | 0 |
21/07/2021 | Wed | 0 |
22/07/2021 | Thu | 0 |
23/07/2021 | Fri | 0 |
24/07/2021 | Sat | 8 |
25/07/2021 | Sun | 8 |
26/07/2021 | Mon | 8 |
27/07/2021 | Tue | 8 |
28/07/2021 | Wed | 8 |
29/07/2021 | Thu | 8 |
30/07/2021 | Fri | 0 |
Thanks
MMH
Jul 17 2021 03:13 AM
Returns the number of whole workdays between two dates using parameters to indicate which and how many days are weekend days. Weekend days and any days that are specified as holidays are not considered as workdays.
Syntax find you in the uper Link.
Returns the number of whole working days between start_date and end_date. Working days exclude weekends and any dates identified in holidays. Use NETWORKDAYS to calculate employee benefits that accrue based on the number of days worked during a specific term.
Syntax find you in the uper Link.
I would be happy to know if I could help.
Nikolino
I know I don't know anything (Socrates)
* Kindly Mark and Vote any reply if it helps please, as it will be beneficial to more Community members reading here.