Countif count Sunday to Friday correctly until it reach Saturday in google sheets

Question

I have 14 dates which only 1 fall on a Saturday. I like to count that Saturday and use it in another formula.

=ArrayFormula(COUNTIF((WEEKDAY(D5:D31,1)),"=7"))

However, the answers I get from the formula is 14 and not 1. True holiday counter

Answer 1

You can try

=arrayformula(countif(MAP(tocol(B5:B,1),LAMBDA(a,weekday(a))),"=7"))