network days formula question

[steve400243]

Hello, I use this cell formula to calculate network days based on the dates entered in the cells it looks at. In some cases it will return a negative number like -2 or -3, If the number returned is negative Is there a way to have the cell just read 0? Thank you for your help.

=IF(NETWORKDAYS.INTL(LOOKUP(2,1/($G$3:$G3>0),$G$3:$G3),I3),NETWORKDAYS(LOOKUP(2,1/($G$3:$G3>0),$G$3:$G3),I3,Sheet2!$B$2:$B$7))-1

 

[Fluff]

How about
=MAX(IF(NETWORKDAYS.INTL(LOOKUP(2,1/($G$3:$G3>0),$G$3:$G3),I3),NETWORKDAYS(LOOKUP(2,1/($G$3:$G3>0),$G$3:$G3),I3,Sheet2!$B$2:$B$7))-1,0)

 

[steve400243]

Thank you Fluff, I was missing the "Max" in my testing. Thanks for your time.

 

[CA_Punit]

Can you post a sample data

i am confused as how is this formula working

Anyways Fluff has replied but out of curiosity if you can provide a sample so that i can clear my confusion

I am confused with this.
NETWORKDAYS.INTL(LOOKUP(2,1/($G$3:$G3>0),$G$3:$G3),I3) what will happen if this is Negative Number or 0

 

[Fluff]

You're welcome & thanks for the feedback.

 

[steve400243]

Can you post a sample data

i am confused as how is this formula working

Anyways Fluff has replied but out of curiosity if you can provide a sample so that i can clear my confusion

I am confused with this.
NETWORKDAYS.INTL(LOOKUP(2,1/($G$3:$G3>0),$G$3:$G3),I3) what will happen if this is Negative Number or 0

I use it to count days for an analysis report, G3 is the Unloaded Date. I3 is the Date the needed paperwork is received. No weekends or company holidays are counted. If the number is less than 0, it will record -1, -2 etc. I may have the formula wrong or there may be an easier way?