You might have a problem as you are displaying dates which are numeric as days. If the days are numeric in the calendar then each Friday has a different value from the other Fridays and therefore it will only count once.

If you can set up the table so the day is alpha and not numeric then you could use =COUNTIF(B9:AC9,"Fri")