Networkdays odd behavior

[Jeffrey Green]

Cell G10 = 4/10/2018
Cell L10 = 4/9/2018

(It is ok to have negative days in our business)

M10 = =NETWORKDAYS(G10,L10)-1

The answer is get is -3.



Most of my rows are correct, but i see a few of this type issue.


Thoughts?

 

[Joe4]

The structure of NETWORKDAYS is:
NETWORKDAYS(start date, end date, holidays)

So the earlier date is usually the first date.
Yours is reversed, so it will return -2 instead of 2.
And then is it just simple math, subtracting -1 from -2 gives you -3.
So that is expected behavior.

If the answer you are looking for is 1, because you want it to say 2 workdays minus 1 is 1, and you don't want to change the order of the fields in your formula, then change it to:

[COLOR=#333333]=ABS(NETWORKDAYS(G10,L10))-1[/COLOR]

 

[Jeffrey Green]

THanks Joe . .. the order of dates is correct, but i dont want to count the first day, that is why i do +1. But if we release something before it arrives (which can happen), I want something like....IF the original networkdays is negative, then instead of subtracting one, i need to ADD 1. I cant seem to get that to work, though. help! thanks

 

[Joe4]

Try:

[COLOR=#333333]=NETWORKDAYS(G10,L10) + IF(G10>L10,1,-1)[/COLOR]

 

[MARK858]

Deleted as better solution in previous post by Joe4.

 

[Jeffrey Green]

unless there is a cleaner way, this appears to work . . . .

thanks

=IF(NETWORKDAYS(G83,L83)-1 < 0,NETWORKDAYS(G83,L83)+1,NETWORKDAYS(G83,L83)-1)

 

[Joe4]

unless there is a cleaner way, this appears to work . . . .

thanks

=IF(NETWORKDAYS(G83,L83)-1 < 0,NETWORKDAYS(G83,L83)+1,NETWORKDAYS(G83,L83)-1)

The answer I posted up in post 4 only involves a single NETWORKDAYS calculation, so it should be more efficient.

 

[Jeffrey Green]

yes, joe, yours is better . . . sorry, i hadnt seen that reply when I replied, thanks for taking the time!