count public holiday weekdays in date range

[ajm]

i need to count the number or weekday public holidays that fall between certain dates. In this instance, i am looking for the weekday public holidays that fall in Ramadan.
This year, Ramadan is 22/3/2023 - 21/04/2023. Easter public holidays are also within that date range. The public holiday dates are in the range "PubHols". Now I know its two, but i would like a formula to do the calculation for this model i am building. Can anyone assist?

 

[awoohaw]

@ajm , you can use the NETWORKDAYS.INTL function.

Mr excel questions 41.xlsm
	A	B	C	D	E	F
1
2	Start	End		Weekend:		PubHols
3	2023-05-01	2023-07-31		Sat, Sun		Thu 2023-06-15
4						Thu 2023-07-20
5	NETWORKDAYS.INTL:
6	64
sjm

Cell Formulas
Range	Formula
A6	A6	=NETWORKDAYS.INTL(A3,B3,1,$F$3:$F$5)

 

[awoohaw]

or if you wanted to use the rangename for the public holidays:

=NETWORKDAYS.INTL(A3,B3,1,PubHols)

 

[Tetra201]

See if the following formula works for you:

=NETWORKDAYS(A3,B3)-NETWORKDAYS(A3,B3,PubHols)

 

[awoohaw]

See if the following formula works for you:

=NETWORKDAYS(A3,B3)-NETWORKDAYS(A3,B3,PubHols)

ah, I read the Original post incorrectly. This is a good answer.

 

[ajm]

Thanks for responding @awoohaw and @Tetra201