I’m trying to write a formula to count public holidays between two given dates from a holiday list. Meanwhile, I need to exclude a holiday date if it is a weekend (Saturday or Sunday).

My trial formula: =COUNTIFS(Holiday_Range,”>=”&Date1,Holiday_Range,”<=”&Date2)
But that formula counts all listed dates even if it is Saturday or Sunday.

I would appreciate any support in that.

My Holiday List

I’m expecting 5 days out of the below list. But the result is 8 !!

New Year’s Day Sat 1-Jan-2022
Fasching Mon 28-Feb-2022
Women’s Day Tue 8-Mar-2022
Good Friday Fri 15-Apr-2022
Easter Monday Mon 18-Apr-2022
Labour Day Sun 1-May-2022
Mother’s Day Sun 8-May-2022
Ascension Day Thu 26-May-2022