I am working on a formula for days it took to complete a task.
Date task entered is column N
Date task finalized is column O
My current formula is =networkdays(N2,O2,List!$H$3:$H$26)-1
The list is our holidays observed. Normal work week is Monday through Friday.
The problem I am having is if someone works on a weekend and the date entered and date finalized are on that same day (weekend) it is producing a negative number vs zero.
Example.
Entered on 01/15/2023
Finalized on 01/15/2023
Is producing a -1 and I need it to be zero.
How do I update this formula to account for if weekends are worked?
Date task entered is column N
Date task finalized is column O
My current formula is =networkdays(N2,O2,List!$H$3:$H$26)-1
The list is our holidays observed. Normal work week is Monday through Friday.
The problem I am having is if someone works on a weekend and the date entered and date finalized are on that same day (weekend) it is producing a negative number vs zero.
Example.
Entered on 01/15/2023
Finalized on 01/15/2023
Is producing a -1 and I need it to be zero.
How do I update this formula to account for if weekends are worked?