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
Muhammad Shehata is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.