workday() and networkdays() are got given the same result

[lezawang]

Hi
I tried to use workday() and networkdays() to see the difference. I am surprised that I got different result. I live in Canada and today is holiday. I did not enter any holiday in the workday() function

[TABLE="width: 500"]
<tbody>[TR]
[TD]task[/TD]
[TD]start date[/TD]
[TD]# of days[/TD]
[TD]=WORKDAY(B2,C2)[/TD]
[TD]=NETWORKDAYS(B2,D2)[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][TABLE="width: 84"]
<tbody>[TR]
[TD="class: xl64, width: 84, align: right"]09/10/2017[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]11[/TD]
[TD][TABLE="width: 100"]
<tbody>[TR]
[TD="class: xl65, width: 100, align: right"]24/10/2017[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 211"]
<tbody>[TR]
[TD="width: 211, align: right"]12[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]

 

[AlphaFrog]

The WORKDAY function returns the date after the Start date. The Start date is not counted e.g.; If you did one workday...
=WORKDAY(Date, 1)
...it returns the date of the next workday

The NETWORKDAYS function counts the number of workdays including the start date e.g.; if you gave it two consecutive workday dates
=NETWORKDAYS(Date, Date+1)
... it returns a value of 2.