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

[TABLE="width: 894"]
<tbody>[TR]
[TD]Submit[/TD]
[TD]Review[/TD]
[TD]Turnaround[/TD]
[TD]Formula in C[/TD]
[TD]Turnaround[/TD]
[TD]Formula in E[/TD]
[TD]Turnaround[/TD]
[TD]Formula in G[/TD]
[/TR]
[TR]
[TD="align: right"]24/10/2016[/TD]
[TD="align: right"]24/10/2016[/TD]
[TD="align: right"]-2[/TD]
[TD]'=NETWORKDAYS((A2+1),B2)[/TD]
[TD="align: right"]-1[/TD]
[TD]'=NETWORKDAYS((A2),B2-1)[/TD]
[TD="align: right"]0[/TD]
[TD]'=NETWORKDAYS((A2),B2)-1[/TD]
[/TR]
[TR]
[TD="align: right"]24/10/2016[/TD]
[TD="align: right"]25/10/2016[/TD]
[TD="align: right"]1[/TD]
[TD] [/TD]
[TD="align: right"]1[/TD]
[TD] [/TD]
[TD="align: right"]1[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="align: right"]24/10/2016[/TD]
[TD="align: right"]26/10/2016[/TD]
[TD="align: right"]2[/TD]
[TD] [/TD]
[TD="align: right"]2[/TD]
[TD] [/TD]
[TD="align: right"]2[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="align: right"]24/10/2016[/TD]
[TD="align: right"]27/10/2016[/TD]
[TD="align: right"]3[/TD]
[TD] [/TD]
[TD="align: right"]3[/TD]
[TD] [/TD]
[TD="align: right"]3[/TD]
[TD] [/TD]
[/TR]
</tbody><colgroup><col span="2"><col><col><col><col><col><col></colgroup>[/TABLE]

 

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