vba to check if dates overlap

[LFKim2018]

how do we check via VBA or formula if dates overlap each other?
date1: start date: 9-9-2018 end date: 10-8-2018
date2: start date: 9-22-2018 end date: 10-20-2018
date3: start date: 10-10-2018 end date: 11-15-2018
date2 overlaps with date1 while date3 overlaps with date2 etc
many many thanks

 

[Yongle]

Excel 2016 (Windows) 32 bit

	A​	B​	C​
1​	start	end
2​	09-09-2018​	10-08-2018​	TRUE​
3​	09-22-2018​	10-20-2018​	TRUE​
4​	10-10-2018​	11-15-2018​	TRUE​

<tbody>
</tbody>

Sheet: Sheet5

<tbody>
</tbody>

Formula in C2
Excel 2016 (Windows) 32 bit

	C​
2​	=SUMPRODUCT((A2<=B:B)*(B2>A:A))>1​

<tbody>
</tbody>

Sheet: Sheet5

<tbody>
</tbody>

Conditional formatting
If you prefer to use conditional formatting - here is a tutorial displaying that method

 

[LFKim2018]

Mr. Yongle
thank you very much for your reply..