Weekends are a problem for me….

[Jayme580]

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?

 

[Fluff]

How about

=MAX(0,NETWORKDAYS(N2,O2)-1,List!$H$3:$H$26)

 

[Anthony47]

A simple solution:

=MAX(NETWORKDAYS(N2,O2,List!$H$3:$H$26)-1,0)

 

[Anthony47]

@Fluff Please remove my message

 

[Fluff]

No need. Great minds think alike

 

[Jayme580]

@Fluff Please remove my message

A simple solution:

=MAX(NETWORKDAYS(N2,O2,List!$H$3:$H$26)-1,0)[/C
[/QUOTE]

A simple solution:

=MAX(NETWORKDAYS(N2,O2,List!$H$3:$H$26)-1,0)

@Anthony47 that was what I needed! Thank you!

 

[Fluff]

Glad we could help & thanks for the feedback.