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.

		01/10/2018	01/11/2018	01/12/2018	01/01/2019	01/02/2019	01/03/2019	01/04/2019	01/05/2019	01/06/2019	01/07/2019	01/08/2019
		31/10/2018	30/11/2018	31/12/2018	31/01/2019	28/02/2019	31/03/2019	30/04/2019	31/05/2019	30/06/2019	31/07/2019	31/08/2019
Start Date	End Date	Oct 2018-19	Nov 2018-19	Dec 2018-19	Jan 2018-19	Feb 2018-19	Mar 2018-19	Apr 2019-20	May 2019-20	Jun 2019-20	Jul 2019-20	Aug 2019-20
01/01/2019	31/03/2021	0	0	0	22	20	21	21	21	20	15	11
01/10/2018	31/03/2021	23	22	9	22	20	21	21	21	20	15	11
01/10/2018	31/03/2021	23	22	9	22	20	21	21	21	20	15	11
01/10/2018	30/11/2018	23	22	0	0	0	0	0	0	0	0	0

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

 

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