- if you need all days:
=QUERY(ARRAYFORMULA(IF(LEN(A2:A), TEXT(A2:A, "dddd"),)),
"select Col1,count(Col1) where Col1<>'' group by Col1 label count(Col1)''")
- if you need all days from a certain time period:
=QUERY(ARRAYFORMULA(FILTER(TEXT(A2:A, "dddd"),
A2:A>=DATE(2019,4,1),
A2:A<=DATE(2019,4,22))),
"select Col1,count(Col1) where Col1<>'' group by Col1 label count(Col1)''")
- if you need all unique days per week:
=QUERY(ARRAYFORMULA(TEXT(SUBSTITUTE(TEXT(UNIQUE(IF(LEN(A2:A),
DATE(20&MID(A2:A, 7, 2), LEFT(A2:A, 2), MID(A2:A, 4, 2)), )),
"dd/mm/yyyy"), "30/12/1899",""), "dddd")),
"select Col1,count(Col1) where Col1<>'' group by Col1 label count(Col1)''")
- locale fix:
=QUERY(ARRAYFORMULA(TEXT(SUBSTITUTE(TEXT(UNIQUE(IF(LEN(A2:A);
DATE(20&MID(A2:A; 7; 2); LEFT(A2:A; 2); MID(A2:A; 4; 2)); )); "mm/dd/yyyy");
"12/30/1899";""); "dddd"));
"select Col1,count(Col1) where Col1<>'' group by Col1 label count(Col1)''")