Add Days to Date, INCLUDE weekends, but exclude holidays

[fatekeeper]

I am trying to calculate a ship date based on lead times for a factory with 7 day a week operation, but I want to exclude a list of holidays that the factory is closed.
I have the holidays listed in a table (on another tab).

This is the formula I am trying to use but get a #NUM! error.
Cell B2 represents my start date, cell H2 is the lead time in calendar days, 0 represents weekend days (I entered as 0000000 because 0 is working days and 1 is non-working days), and the HolidayTbl[Closure Dates] is the table of holiday closures (table name is HolidayTbl) pointing to the column [Closure Dates]that contains the dates.

What am I doing wrong here? Is it the "0" for zero weekend days? Is there a better function to use?

=WORKDAY.INTL(B2,H2,0,HolidayTbl[Closure Dates])

Thanks

 

[Fluff]

Hi & welcome to MrExcel.
It needs to be

=WORKDAY.INTL(B2,H2,"0000000",HolidayTbl[Closure Dates])

 

[fatekeeper]

Hi & welcome to MrExcel.
It needs to be

=WORKDAY.INTL(B2,H2,"0000000",HolidayTbl[Closure Dates])

Thank you! I originally entered it that way and Excel changed it to a "0". I didn't think to just copy and paste the formula into the cell instead of using the formula tool, but it worked.

 

[Fluff]

You're welcome & thanks for the feedback.

I originally entered it that way and Excel changed it to a "0"

I suspect that you did not put the 0s in quotes.

 

[fatekeeper]

I think you are correct! <facepalm> I'm slightly embarrassed that I missed that.
Thank you again. This is such a helpful forum!

 

[Fluff]

I'm slightly embarrassed that I missed that.

No need to be, we've all been there.