I have a timestamp in
mm/dd/yy hh:mm:ss format from January to March. How do I 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
I need to know how many Mondays from Jan to Mar and by manually calculating there are 7 Mondays in my data (A1:A199) and 8 Thursdays and 9 Saturdays.