I have a timestamp in
mm / dd / yy hh: mm: ss format from January to March. How to count "how many days are Monday" in the range of A1: A199? (Or how many are Tuesday, Wednesday, Saturday?)
This gives me a value of
= ArrayFormula (COUNTUNIQUE (TEXT (A2: A199, "ddd")))
I need to know how many Mondays from January to March and manually calculating there are 7 Mondays in my data (A1: A199) and 8 Thursdays and 9 Saturdays.