Networkdays formula issues

[exceluser9]

Hi Team,

Im using formula =NETWORKDAYS to calculate the days but the number are populating incorrectly for different dates. For all it should remain 2? Is there any other formula to correct these issues?

[TABLE="width: 216"]
<colgroup><col span="2"><col></colgroup><tbody>[TR]
[TD]Date[/TD]
[TD]Date[/TD]
[TD]Days[/TD]
[/TR]
[TR]
[TD]29/05/2019[/TD]
[TD]31/05/2019[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]10/07/2019[/TD]
[TD]12/07/2019[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]05/07/2019[/TD]
[TD]08/07/2019[/TD]
[TD]2[/TD]
[/TR]
</tbody>[/TABLE]

 

[JonXL]

It works as intended from what I can see in your sample.

Note: NETWORKDAYS includes the first and last day in the count of the number of days.