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?

Date	Date	Days
29/05/2019	31/05/2019	3
10/07/2019	12/07/2019	3
05/07/2019	08/07/2019	2

<colgroup><col span="2"><col></colgroup><tbody>
</tbody>

 

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