Hi,
I have an issue with function “NETWORKDAYS.INTL”. I want the holidays in this function to be more dynamic.
I want, for example, to exclude only holidays for month 12/2019, month 11/2019, month 10/2019, and so on.
This is my situation (Excel file is attached):
=NETWORKDAYS.INTL(H14,H15,7,{"11/12/2019","25/12/2019"})
I want to replace holidays ({"11/12/2019","25/12/2019"}) to be dynamic from range A3:A14 and only retrieve holidays between H14 and H15.
Note: The date format I used in the Attached Excel file is "dd/mm/yyyy".
Thanks a lot.
Bookmarks