Need help with the below table.
Ticket open date | Ticket resolved date | Net working days | Within / outside limit |
3/18/2023 3:55:36 AM | 3/23/2023 9:36:38 PM | 4 | Outside limit |
If the networking days are less than 4, then it is considered "within limit"; otherwise, it is "outside limit". However, if there is a holiday between the ticket open date and resolved date, the net working days column will remain the same, but the limit for networking days will increase by the number of holidays. For example, if there is one holiday between the open and resolved dates, then the limit should be 5 for evaluating whether it is within or outside the limit.
For this, i have a list of holidays in a separate input file. Please help me incorporate this in my workflow.
Thanks
@harithad1
What have you done so far to resolve that issue? Or what is your thought process on how to solve it from the given data?
@harithad1
share the workflow
will be in better condition to help.