Using IF Function with multiple dates

[MedInformatTiff]

Hello,

I have two worksheets in my workbook. The first sheet has a list of patients (all patients have unique identifiers i.e 123456 as their patient number) with all of their office visits listed. The second sheet is the same group of patients with all of their hospital discharge dates listed. I'm trying to compare IF any of the unique patients' hospital discharge date/s are within 30 days of any of their office visit dates then I want it to display TRUE.

Please help!

 

[mart37]

Maybe this will help you on your way.

Excel Workbook
	A	B	C	D	E	F	G	H
1	nr	visite 1	visite 2			nr	discharge	30 days
2	5	4-2-2017	4-1-2017			5	4-2-2017	1
3	10	1-1-2017	4-2-2017			10	7-1-2017	2
tables visits/discharges