How to make Networkdays formula display less than 0 values
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.
Help Article Resources
Check out the Formula Handbook template!