If function to exclude weekends and Holidays

[Bazabelle]

Hi,

Not sure how to use this formula from another post; =IF(AND(WORKDAY(C3,0)=WORKDAY(TODAY(),0),E3<>""),E3,"")

Currently I have this one which works perfectly but I want to exclude any Holidays

=IF(WEEKDAY(E4+D6, 2)= 7,E4+D6+1,IF(WEEKDAY(E4+D6,2)= 6,E4+D6+2, E4+D6))

E4 = 16Aug2023
D6 = 6

 

[MARK858]

Book1
	A	B	C	D	E	F	G	H
1	20/12/2023	6	02/01/2024					Holidays
2	24/11/2023		30/11/2023					25/12/2023
3								26/12/2023
4								27/12/2023
5								28/12/2023
6								29/12/2023
7								30/12/2023
8								31/12/2023
9								01/01/2024
Sheet1

Cell Formulas
Range	Formula
C1:C2	C1	=WORKDAY(A1+5,$B$1-5,$H$2:$H$9)

or more generic

Book1
	A	B	C	D	E	F	G	H
1	20/12/2023	6	02/01/2024					Holidays
2	24/11/2023		30/11/2023					25/12/2023
3								26/12/2023
4								27/12/2023
5								28/12/2023
6								29/12/2023
7								30/12/2023
8								31/12/2023
9								01/01/2024
Sheet1

Cell Formulas
Range	Formula
C1:C2	C1	=WORKDAY(A1+($B$1-1),$B$1-$B$1+1,$H$2:$H$9)

or

=WORKDAY(A1+($B$1-1),1,$H$2:$H$9)