Count days at work that were fridays

[Dazzybeeguy]

Column A1:A24 is a list of dates
Column B is a list of names
Column D is a list of names

Q: what is the best way to count how may times a particular person worked on a Friday.

So assume column D has the filtered Unique list of name say D1:D10 and Bob Jones is in column D1

I want to put a formula in say cell E1 that says look at column A and every time Bob Jones is in column B and the date falls on a Friday, give me a total.

Mon/18/11/2024	Bob Jones		Bob Jones	????
Mon/18/11/2024	Arthur Askey		Arthur Askey
Mon/18/11/2024	George Lucas		George Lucas
Tue/19/11/2024	Brad Pitt		Brad Pitt
Tue/19/11/2024	Bob Jones		Donal Duck
Tue/19/11/2024	Donal Duck		Martha Jackson
Wed/20/11/2024	Martha Jackson		Mike Hunt
Wed/20/11/2024	Martha Jackson		Tod the Bod
Wed/20/11/2024	Bob Jones		Lisa Lee
Thu/21/11/2024	Arthur Askey		Ian Jones
Thu/21/11/2024	George Lucas
Thu/21/11/2024	Brad Pitt
Fri/22/11/2024	Mike Hunt
Fri/22/11/2024	Tod the Bod
Fri/22/11/2024	Lisa Lee
Sat/23/11/2024	Lisa Lee
Sun/24/11/2024	Bob Jones
Mon/25/11/2024	Ian Jones
Mon/25/11/2024	George Lucas
Mon/25/11/2024	Brad Pitt
Tue/26/11/2024	Bob Jones
Tue/26/11/2024	Donal Duck
Tue/26/11/2024	Martha Jackson
Wed/27/11/2024	Bob Jones

 

[6StringJazzer]

Is the data in column A text, or are they dates with custom formatting?

 

[Vogateer]

If Column A is just text, then I think this will work:

=SUM(--($B$1:$B$24=D1)*(LEFT($A$1:$A$24,3)="Fri"))

 

[Dave Patton]

If the date column includes dates not text, try one of the following depending on which version of Excel you are using.

Dates and Time 2024.xlsm
	A	B	C	D	E	F
1			Excel V		365	2010
2	Mon 18-11-24	Bob Jones		Bob Jones	1	1
3	Mon 18-11-24	Arthur Askey		Arthur Askey	0	0
4	Mon 18-11-24	George Lucas		George Lucas	0	0
5	Tue 19-11-24	Brad Pitt		Brad Pitt	0	0
6	Fri 15-11-24	Bob Jones		Donal Duck	2	2
7	Fri 22-11-24	Donal Duck		Martha Jackson	0	0
8	Fri 22-11-24	Donal Duck		Mike Hunt	0	0
5c

Cell Formulas
Range	Formula
E2:E8	E2	=SUMPRODUCT(--($B$2:$B$8=D2),--(WEEKDAY($A$2:$A$8,1)=6))
F2:F8	F2	=SUM(($B$2:$B$8=D2)*(WEEKDAY($A$2:$A$8,1)=6))