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.
<colgroup><col><col><col span="9"><col span="2"></colgroup><tbody>
</tbody>
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>