How to make Networkdays formula display less than 0 values

Linda Armstrong

Hello,

I am having multiple issues with my calculations using MAX and NETWORKDAYS. In the “Invoice Variance” field my numbers are displaying as negative numbers using the following formula =MAX(NETWORKDAYS([Invoice Submission Due Date]@row, [Original Invoice Receipt Date]@row, [Resubmitted Invoice Receipt Date]1:[2nd Resubmitted Invoice Receipt Date]1)) - 1. I need the formula to display “0” instead of negative numbers.

Can someone assist with a formula to resolve this issues. 

Paul Newcome

You could wrap the whole thing in another MAX function to output the MAX of that or zero.

=MAX(0, MAX(NETWORKDAYS([Invoice Submission Due Date]@row, [Original Invoice Receipt Date]@row, [Resubmitted Invoice Receipt Date]1:[2nd Resubmitted Invoice Receipt Date]1)) - 1)

Paul Newcome

You could wrap the whole thing in another MAX function to output the MAX of that or zero.

=MAX(0, MAX(NETWORKDAYS([Invoice Submission Due Date]@row, [Original Invoice Receipt Date]@row, [Resubmitted Invoice Receipt Date]1:[2nd Resubmitted Invoice Receipt Date]1)) - 1)

Linda Armstrong

Good morning @Paul Newcome!

I tried many formulas from the discussion topics but I just couldn't get any of them to work. Now I see I was applying it incorrectly. I was placing the 0 before the Networkdays formula (=MAX(0, NETWORKDAYS…..

Thank you so much it worked like a charm!

Paul Newcome

Happy to help. 👍️