Networkdays problem

[logstarter]

Hi, I am using networkdays to check the date difference. I found that for the cases with two same dates, some records return 0 but some return -1.. I try to use if statement to compare those 2 dates, they are return yes (the same)... I can't figure out the reasons so I would like to ask the possible cause of that....

Thank you for your help.

 

[arthurbr]

Don't know about -1 but NETWORKDAYS should only return 0 if the -same- dates are a holiday and entered as such in the function.
Normal NETWORKDAYS should return 1 for difference between two identical dates
=networkdays(19/10/20,19/10/20,19/10/20) =0
and
=networkdays(19/10/20,19/10/20) =1