Start and End NETWORKDAYS by month

[K3rmit]

Hi

I need some help with formula/ function to return NETWORKDAYS per month based on Start Date and End date (including public, annual holidays). I've tried to use IF(AND and I always have too many arguments to get the correct result (exact number of WDs be per month based on start and end date inc. holidays).

Thanks.



[TABLE="width: 996"]
<colgroup><col><col><col span="9"><col span="2"></colgroup><tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD="align: right"]01/10/2018[/TD]
[TD="align: right"]01/11/2018[/TD]
[TD="align: right"]01/12/2018[/TD]
[TD="align: right"]01/01/2019[/TD]
[TD="align: right"]01/02/2019[/TD]
[TD="align: right"]01/03/2019[/TD]
[TD="align: right"]01/04/2019[/TD]
[TD="align: right"]01/05/2019[/TD]
[TD="align: right"]01/06/2019[/TD]
[TD="align: right"]01/07/2019[/TD]
[TD="align: right"]01/08/2019[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD="align: right"]31/10/2018[/TD]
[TD="align: right"]30/11/2018[/TD]
[TD="align: right"]31/12/2018[/TD]
[TD="align: right"]31/01/2019[/TD]
[TD="align: right"]28/02/2019[/TD]
[TD="align: right"]31/03/2019[/TD]
[TD="align: right"]30/04/2019[/TD]
[TD="align: right"]31/05/2019[/TD]
[TD="align: right"]30/06/2019[/TD]
[TD="align: right"]31/07/2019[/TD]
[TD="align: right"]31/08/2019[/TD]
[/TR]
[TR]
[TD]Start Date [/TD]
[TD]End Date[/TD]
[TD]Oct 2018-19[/TD]
[TD]Nov 2018-19[/TD]
[TD]Dec 2018-19[/TD]
[TD]Jan 2018-19[/TD]
[TD]Feb 2018-19[/TD]
[TD]Mar 2018-19[/TD]
[TD]Apr 2019-20[/TD]
[TD]May 2019-20[/TD]
[TD]Jun 2019-20[/TD]
[TD]Jul 2019-20[/TD]
[TD]Aug 2019-20[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]01/01/2019 [/TD]
[TD]31/03/2021[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]22[/TD]
[TD="align: right"]20[/TD]
[TD="align: right"]21[/TD]
[TD="align: right"]21[/TD]
[TD="align: right"]21[/TD]
[TD="align: right"]20[/TD]
[TD="align: right"]15[/TD]
[TD="align: right"]11[/TD]
[/TR]
[TR]
[TD]01/10/2018[/TD]
[TD]31/03/2021[/TD]
[TD="align: right"]23[/TD]
[TD="align: right"]22[/TD]
[TD="align: right"]9[/TD]
[TD="align: right"]22[/TD]
[TD="align: right"]20[/TD]
[TD="align: right"]21[/TD]
[TD="align: right"]21[/TD]
[TD="align: right"]21[/TD]
[TD="align: right"]20[/TD]
[TD="align: right"]15[/TD]
[TD="align: right"]11[/TD]
[/TR]
[TR]
[TD]01/10/2018[/TD]
[TD]31/03/2021[/TD]
[TD="align: right"]23[/TD]
[TD="align: right"]22[/TD]
[TD="align: right"]9[/TD]
[TD="align: right"]22[/TD]
[TD="align: right"]20[/TD]
[TD="align: right"]21[/TD]
[TD="align: right"]21[/TD]
[TD="align: right"]21[/TD]
[TD="align: right"]20[/TD]
[TD="align: right"]15[/TD]
[TD="align: right"]11[/TD]
[/TR]
[TR]
[TD]01/10/2018[/TD]
[TD]30/11/2018[/TD]
[TD="align: right"]23[/TD]
[TD="align: right"]22[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[/TR]
</tbody>[/TABLE]

 

[Aladin Akyurek]

What does Oct 2018-19 mean underneath of 2018-10-01 and 2018-10-31?

 

[K3rmit]

Row C is a monthly timeline (in financial years).

Start and End date are in column A and B. ​