In Networkdays formula, we have "holidays" part, where we can easily use excel list of holidays that we created in advance.

But what I want to do is to note holidays in the formula manually (not from existing list). For this reason I write holidays in the Networkdays formula with the help of Datevalue formula. When it is only one holiday, it works. But of course I have several holidays that I should note, and the formula doesn't work.

Maybe you have an idea how I can make Date value work with date ranges?

Thank you in advance