Find any names that match within a 1 month period

[TAPS_MikeDion]

Hi all,

I was hoping someone might have a conditional format formula that would work for this. It's pretty basic, I'm sure, for those of you with extensive Excel knowledge. Anyway, what I'm trying to accomplish is to have Excel search through the LAST NAME, FIRST NAME and DATE columns to find any names that match within a 1 month period. If the dates are more than a month apart, they can be ignored. I would like to have the background change to red and the text to yellow (as seen in the sample) for any match found within the same month.

Thank you very much!

-Mike

Rubber Gloves Dispersement 2021.xlsx
	A	B	C	D	E	F
1	LAST NAME	FIRST NAME	DATE	SIZE	# OF BOXES	NOTES
2	Doe	Jane	1/15/21	X	1
3	Doe	John	1/15/21	L	1
4	Smith	Bob	2/4/21	L	1
5	Williams	Lisa	2/4/21	L	1
6	Williams	Lisa	3/1/21	S	1
7	Stone	Samantha	3/3/21	M	1
8	Rhoads	Schuyler	3/15/21	L	1
9	Stone	Samantha	3/25/21	M	1
10
WIP

 

[Fluff]

How about

+Fluff 1.xlsm
	A	B	C	D	E	F
1	LAST NAME	FIRST NAME	DATE	SIZE	# OF BOXES	NOTES
2	Doe	Jane	15/01/2021	X	1
3	Doe	John	15/01/2021	L	1
4	Smith	Bob	04/02/2021	L	1
5	Williams	Lisa	04/02/2021	L	1
6	Williams	Lisa	01/03/2021	S	1
7	Stone	Samantha	03/03/2021	M	1
8	Rhoads	Schuyler	15/03/2021	L	1
9	Stone	Samantha	25/03/2021	M	1
Main

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A2:F9	Expression	=COUNTIFS($A$2:$A2,$A2,$B$2:$B2,$B2,$C$2:$C2,">"&EOMONTH($C2,-1),$C$2:$C2,"<="&EOMONTH($C2,0))>1	text	NO

 

[TAPS_MikeDion]

Fluff to the rescue. LOL

Hi Fluff,
Thanks for your response. I tried with my actual data (I didn't want to put the real info on here) and your formula works, but only within the same month. It was my fault for not making it absolutely 100% clear. What I'm trying to do is have it check (I guess) within a 30 day span. I stated 1 month, but I don't know if that would involve too much coding.

For example:
6/29/21 - 7/4/21 is only 5 days, which obviously falls within the 30 day period.

Thank you again.

 

[Fluff]

Ok, how about

=COUNTIFS($A$2:$A2,$A2,$B$2:$B2,$B2,$C$2:$C2,">="&$C2-15,$C$2:$C2,"<="&$C2+15)>1

 

[TAPS_MikeDion]

PERFECT!!!

Thank you again!

 

[Fluff]

You're welcome & thanks for the feedback.