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

task	start date	# of days	=WORKDAY(B2,C2)	=NETWORKDAYS(B2,D2)
	09/10/2017 <tbody> </tbody>	11	24/10/2017 <tbody> </tbody>	12 <tbody> </tbody>

<tbody>
</tbody>

 

[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.