Add workdays from date entered

[Tazzbjs]

Ok, been digging around and haven't found the perfect answer yet so time to ask. I need B2 to add 10 workdays (no weekends or holidays) to the date entered in A2. What I have below is excluding the weekend, but not Thanksgiving. As always, any assistance is greatly appreciated.

 

[Fluff]

The final argument for Workday is holidays, you can create a list of holidays & then use that range as the final argument.

 

[Tazzbjs]

The final argument for Workday is holidays, you can create a list of holidays & then use that range as the final argument.

I tried that, and just received an error.

 

[Fluff]

It should be like

=WORKDAY(A2,10,Sheet2!A1:A4)

 

[Tazzbjs]

Thank-you Fluff!

 

[Fluff]

You're welcome & thanks for the feedback.