Clarification on Networkdays

[cud22]

Hi all, I need to calculate the difference between 2 days (networkdays function), and then subtract one. EG start date today, end date tomorrow returns the value of 1.

I have done this by adding / subtracting from start date, end date and from the formula result. I would expect each of these to return the same value, but they do not when the start and end dates are the same. Why is this?

Sample Table

Submit	Review	Turnaround	Formula in C	Turnaround	Formula in E	Turnaround	Formula in G
24/10/2016	24/10/2016	-2	'=NETWORKDAYS((A2+1),B2)	-1	'=NETWORKDAYS((A2),B2-1)	0	'=NETWORKDAYS((A2),B2)-1
24/10/2016	25/10/2016	1		1		1
24/10/2016	26/10/2016	2		2		2
24/10/2016	27/10/2016	3		3		3

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

 

[FormR]

I would expect each of these to return the same value, but they do not when the start and end dates are the same. Why is this?

Hi, because when you subtract 1 from the 24/10/2016 it's a Sunday so is excluded. But when you add 1 to the 24/10/2016 it's a Tuesday so is not excluded.

 

[cud22]

Thanks. That explains it!