Count day name in list of dates

[Raggy]

This is the basics of what I want, I am supplied a list of dates in the format 19/04/2022 which I format the columns to show the day of the week. I need to collate how many Tuesdays there are in that list for example but honestly struggling to get my head around it. Any help appreciated

 

[kweaver]

What about:

TEST.xlsx
	B	C	D	E	F	G	H
1							List
2	Day	Mon	Tue	Wed	Thur		Mon 11/04/2022
3		3	1	1	0		Tue 12/04/2022
4							Wed 13/04/2022
5							Mon 25/04/2022
6							Thu 28/04/2022
7							Mon 18/04/2022
report

Cell Formulas
Range	Formula
C3:F3	C3	=SUM(--(TEXT($H2:$H7,"ddd")=C2))

 

[Raggy]

Looks promising, but what I want to do in the end is to use it as part of an countifs statement so it becomes the criteria
=countifs(j:j, "Email", h:h, C2) as I have a column that has the call type in it so I need to match the days that emails came on, i.e. count all days in column J that were 'email' and also matched the day name in C2. Hope that makes sense. Didnt want to complicate the original question. Thanks for the suggestion so far though.

 

[kweaver]

If you can't work it from my formula, show show details. Please use XL2BB when posting examples rather than an image.