How to find duplicates within 5 days of each other in data set

[szita2000]

	A	B	C	D	E
1	Date	Name	Product	Concan	Count
2	01/01/2018	Daffy Duck	Apple	Daffy DuckApple	0
3	03/01/2018	Bugs Bunny	Pear
4	03/01/2018	Bugs Bunny	Orange
5	07/01/2018	Bugs Bunny	Orange
6	12/01/2018	Pepe Le Pew	Kiwi
7	05/01/2018	Daffy Duck	Apple

<tbody>
</tbody>

Sheet1​

Worksheet Formulas Cell Formula D2 =B2&C2 E2 =COUNTIFS($D:$D,$D2,$A:$A,$A2>=($A2+5),$A:$A,$A2<=($A2+5)) <tbody> </tbody>

<tbody>
</tbody>

Hi Guys. I can't figure this one out. In the data set above I have to highlight duplicates that are occur within 5 days of each other. (This is to filter out of someone processed the same purchasing twice by accident) I tried to concatenate the name and product in to a helper column on D:D - That would make each purchase unique, I can't work out how to collect and compare the date after the combinations. I tried to go with count ifs but the criterias of >= than date +5 days doesn't seems to be working. In the data set above Line 2,7 and 4,5 should be highlighted/put in to a separate list somehow Any ideas most welcome

<tbody>
</tbody>

 

[VBA Geek]

You are almost there I think:

Excel 2010
	A	B	C	D
1	Date	Name	Product	dupe?
2	1/1/2018	Daffy Duck	Apple	TRUE
3	1/3/2018	Bugs Bunny	Pear	FALSE
4	1/3/2018	Bugs Bunny	Orange	TRUE
5	1/8/2018	Bugs Bunny	Orange	TRUE
6	1/12/2018	Pepe Le Pew	Kiwi	FALSE
7	1/5/2018	Daffy Duck	Apple	TRUE
Sheet2

Cell Formulas
Range	Formula
D2	=COUNTIFS($B$2:$B$7,B2,$C$2:$C$7,C2,$A$2:$A$7,"<"&A2+6,$A$2:$A$7,">"&A2-6)>1
D3	=COUNTIFS($B$2:$B$7,B3,$C$2:$C$7,C3,$A$2:$A$7,"<"&A3+6,$A$2:$A$7,">"&A3-6)>1
D4	=COUNTIFS($B$2:$B$7,B4,$C$2:$C$7,C4,$A$2:$A$7,"<"&A4+6,$A$2:$A$7,">"&A4-6)>1
D5	=COUNTIFS($B$2:$B$7,B5,$C$2:$C$7,C5,$A$2:$A$7,"<"&A5+6,$A$2:$A$7,">"&A5-6)>1
D6	=COUNTIFS($B$2:$B$7,B6,$C$2:$C$7,C6,$A$2:$A$7,"<"&A6+6,$A$2:$A$7,">"&A6-6)>1
D7	=COUNTIFS($B$2:$B$7,B7,$C$2:$C$7,C7,$A$2:$A$7,"<"&A7+6,$A$2:$A$7,">"&A7-6)>1

 

[szita2000]

Thanks a mill VBA Geek!