Workday.intl function--Holidays help

I need to create a production schedule for multiple projects. I need to input a formula that will take the start date (in the D column) and the number of days a crew will be working on a given project (in the I column) to get an approximate finish date. Obviously the finish date has to take weekends and holidays into consideration. And it's that last part I'm having issues with, specifically the floating holidays like Thanksgiving. The solutions I've seen on this site require having the specific holidays in the sheet with the other data, which I don't want. I'd also like the formula to work for not just this year, but the next and the one after that, etc.

Is it possible to do this? I've attached an example schedule just in case that helps at all.Roofing Production Schedule Help.xlsx

Thanks in advance!

Unfortunately, there is no built in feature that tells Excel which dates are holidays.
Pretty much because what qualifies as a Holiday varies greatly from one person/company/city/state/country to the next.
So there can't really be any MASTER list that Excel can use.

So there's really no getting aruond it.
You MUST in one way or another actually create your own list of dates that are considered holidays.

Now if it's just that you don't want that list to be on the same sheet with your data, you can put it on a hidden sheet.
You can even put them in a Named Range, so they're not actually on a sheet, but stored in memory.

Originally Posted by Jonmo1

Unfortunately, there is no built in feature that tells Excel which dates are holidays.
Pretty much because what qualifies as a Holiday varies greatly from one person/company/city/state/country to the next.
So there can't really be any MASTER list that Excel can use.

So there's really no getting aruond it.
You MUST in one way or another actually create your own list of dates that are considered holidays.

Now if it's just that you don't want that list to be on the same sheet with your data, you can put it on a hidden sheet.
You can even put them in a Named Range, so they're not actually on a sheet, but stored in memory.

That makes sense. I went and created a Named Range, and it looks like that was a success! Thanks for your help!

Great, glad to help out.