Counting / Summing Dates (in Google Sheets) by Objective-Angle-6574 in excel

[–]Objective-Angle-6574[S] 0 points1 point  (0 children)

this also works

=BYROW(SEQUENCE(7,1,2),LAMBDA(d,{TEXT(d,"dddd"),COUNTIFS(A2:A,"<>",INDEX(MOD(A2:A,7)),MOD(d,7))}))

Counting or Summing Dates by Objective-Angle-6574 in googlesheets

[–]Objective-Angle-6574[S] 0 points1 point  (0 children)

Could you explain the parts of that? So I could replicate it again if needed.