Max Date excluding weekends and holidays

[Caveman1964]

I need a formula to give me the maximum date plus 3 days from Z7:AI7 and exclude holidays and weekends.
I have all my holidays listed in row 1...B1:OM1 (FOR FUTURE YEARS)
I do have the max date + 3 but cant get the networks days in there correctly. Can someone show my how to nest the networks days in here?
=IFERROR(MAX(Z7:AI7,DATEVALUECALCULATION5,)+3,"")

Any help would be much appreciated!

 

[DRSteele]

I think this is what you're after. The Dates column of my exemplar has dates from 12/20/2018 to 12/31/2019

[FONT=Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif]

Book1
	A	B	C	D	E	F
1	dates	Calgary Holidays	Calgary Holiday Names
2	12/01/18	12/25/18	Christmas Day		Net workdays	272
3	12/02/18	12/26/18	Boxing Day
4	12/03/18	1/01/19	New Year's Day
5	12/04/18	2/18/19	Family Day
6	12/05/18	4/19/19	Good Friday
7	12/06/18	4/22/19	Easter Monday
8	12/07/18	5/20/19	Victoria Day
9	12/08/18	7/01/19	Canada Day
10	12/09/18	8/05/19	Heritage Day
11	12/10/18	9/02/18	Labour Day
12	12/11/18	10/14/19	Thansksgiving Day
13	12/12/18	11/11/19	Remembrance Day
14	12/13/18	12/25/19	Christmas Day
15	12/14/18	12/26/19	Boxing Day
397	12/31/19
Sheet2

Cell Formulas
Range	Formula
F2	=NETWORKDAYS.INTL(MIN(A2:A397),MAX(A2:A397)+3,1,B2:B15)

[/FONT]