IF a cell contains 3 different words then lookup date range to determine conflicts

[abrig005]

Hello,
I am trying to figure out a formula for the following:

if realignment in column A then show the text conflict in column I when transition begins date (B) is >= the solution start date in column D OR
if activation in column A then show the text conflict in column I when transition begins date is <= solution start date in column D OR
if deactivation in column A then show the text conflict in column I when transition begins date is >= the solution start date.

If there is not overlap in dates the text should read no conflict.

In column F and G i was able to show where the overlap in dates are but I can figure out how to incorporate when the transition type is either realignment, activation or deactivation.
the formula in F is =IF(D2>=$B2,IF(D2<=$C2,"Conflict","No Conflict"),"No Conflict")
the formula in D is = =IF(E2>=$B2,IF(E2<=$C2,"Conflict","No Conflict"),"No Conflict")

Thanks for helping !

Column A Column B Column C Column D Column E Column F Column G

Transition Type	Transition Begins	Transition Ends	Solution Start Date	Solution End Date	Start Date Conflict	End Date Conflict
Realignment	11/1/2022​	11/15/2022​	1/15/2022​	3/6/2022​	No Conflict	No Conflict
Realignment	11/1/2022​	11/15/2022​	1/15/2022​	3/16/2022​	No Conflict	No Conflict
Realignment	11/1/2022​	11/15/2022​	6/1/2022​	7/16/2022​	No Conflict	No Conflict
Realignment	11/1/2022​	11/15/2022​	6/1/2022​	7/16/2022​	No Conflict	No Conflict
Realignment	11/1/2022​	11/15/2022​	6/1/2022​	7/16/2022​	No Conflict	No Conflict
Activation	1/1/2022​	1/31/2022​	1/15/2022​	3/6/2022​	Conflict	No Conflict
Deactivation	12/1/2021​	12/15/2021​	1/15/2022​	3/6/2022​	No Conflict	No Conflict
Reorganization	2/6/2022​	2/12/2022​	1/15/2022​	3/6/2022​	No Conflict	No Conflict
Activation	12/1/2021​	12/31/2021​	11/1/2029​	12/31/2029​	No Conflict	No Conflict
Activation	12/1/2021​	12/31/2021​	2/1/2025​	7/31/2025​	No Conflict	No Conflict
Activation	12/1/2021​	12/31/2021​	4/1/2024​	6/29/2024​	No Conflict	No Conflict
Activation	12/1/2021​	12/31/2021​	2/1/2028​	3/2/2028​	No Conflict	No Conflict
Activation	12/1/2021​	12/31/2021​	2/1/2022​	5/20/2025​	No Conflict	No Conflict
Activation	12/1/2021​	12/31/2021​	9/6/2022​	3/16/2023​	No Conflict	No Conflict
Activation	12/1/2021​	12/31/2021​	6/1/2024​	11/28/2024​	No Conflict	No Conflict
Activation	12/1/2021​	12/31/2021​	9/1/2022​	9/7/2022​	No Conflict	No Conflict
Deactivation	10/1/2021​	10/30/2021​	11/1/2029​	12/31/2029​	No Conflict	No Conflict
Deactivation	10/1/2021​	10/30/2021​	2/1/2025​	7/31/2025​	No Conflict	No Conflict
Deactivation	10/1/2021​	10/30/2021​	4/1/2024​	6/29/2024​	No Conflict	No Conflict
Deactivation	10/1/2021​	10/30/2021​	2/1/2028​	3/2/2028​	No Conflict	No Conflict
Deactivation	10/1/2021​	10/30/2021​	2/1/2022​	5/20/2025​	No Conflict	No Conflict
Deactivation	10/1/2021​	10/30/2021​	9/6/2022​	3/16/2023​	No Conflict	No Conflict
Deactivation	10/1/2021​	10/30/2021​	6/1/2024​	11/28/2024​	No Conflict	No Conflict
Deactivation	10/1/2021​	10/30/2021​	9/1/2022​	9/7/2022​	No Conflict	No Conflict
Reorganization	2/1/2022​	2/28/2022​	11/1/2029​	12/31/2029​	No Conflict	No Conflict
Reorganization	2/1/2022​	2/28/2022​	2/1/2025​	7/31/2025​	No Conflict	No Conflict
Reorganization	2/1/2022​	2/28/2022​	4/1/2024​	6/29/2024​	No Conflict	No Conflict
Reorganization	2/1/2022​	2/28/2022​	2/1/2028​	3/2/2028​	No Conflict	No Conflict
Reorganization	2/1/2022​	2/28/2022​	2/1/2022​	5/20/2025​	Conflict	No Conflict
Reorganization	2/1/2022​	2/28/2022​	9/6/2022​	3/16/2023​	No Conflict	No Conflict
Reorganization	2/1/2022​	2/28/2022​	6/1/2024​	11/28/2024​	No Conflict	No Conflict
Reorganization	2/1/2022​	2/28/2022​	9/1/2022​	9/7/2022​	No Conflict	No Conflict
Deactivation	10/1/2021​	9/30/2022​	1/20/2026​	7/19/2026​	No Conflict	No Conflict
Reorganization	10/1/2021​	9/30/2022​	1/20/2026​	7/19/2026​	No Conflict	No Conflict
Reorganization	10/1/2021​	9/30/2022​	9/26/2020​	10/31/2020​	No Conflict	No Conflict
Reorganization	10/1/2021​	9/30/2022​	9/1/2020​	10/31/2020​	No Conflict	No Conflict
Reorganization	10/1/2021​	9/30/2022​	11/30/2021​	5/29/2022​	Conflict	Conflict
Reorganization	10/1/2021​	9/30/2022​	4/2/2022​	5/1/2022​	Conflict	Conflict
Reorganization	10/1/2021​	9/30/2022​	1/1/2022​	1/31/2022​	Conflict	Conflict
Reorganization	10/1/2021​	9/30/2022​	1/1/2022​	1/31/2022​	Conflict	Conflict
Reorganization	10/1/2021​	9/30/2022​	3/17/2022​	4/16/2022​	Conflict	Conflict
Reorganization	10/1/2021​	9/30/2022​	3/17/2022​	4/16/2022​	Conflict	Conflict
Reorganization	10/1/2021​	9/30/2022​	4/5/2022​	5/21/2022​	Conflict	Conflict
Reorganization	10/1/2021​	9/30/2022​	4/1/2022​	5/21/2022​	Conflict	Conflict
Reorganization	10/1/2021​	9/30/2022​	4/1/2022​	4/5/2022​	Conflict	Conflict
Reorganization	10/1/2021​	9/30/2022​	4/1/2022​	4/6/2022​	Conflict	Conflict
Reorganization	10/1/2021​	9/30/2022​	4/1/2022​	5/21/2022​	Conflict	Conflict
Reorganization	10/1/2021​	9/30/2022​	1/1/2022​	1/31/2022​	Conflict	Conflict
Reorganization	10/1/2021​	9/30/2022​	1/1/2022​	1/31/2022​	Conflict	Conflict
Reorganization	10/1/2021​	9/30/2022​	4/2/2022​	5/1/2022​	Conflict	Conflict
Reorganization	10/1/2021​	9/30/2022​	1/1/2022​	1/31/2022​	Conflict	Conflict
Reorganization	10/1/2021​	9/30/2022​	4/2/2022​	5/1/2022​	Conflict	Conflict
Reorganization	10/1/2021​	9/30/2022​	1/1/2022​	1/31/2022​	Conflict	Conflict
Reorganization	10/1/2021​	9/30/2022​	1/1/2022​	1/31/2022​	Conflict	Conflict
Reorganization	10/1/2021​	9/30/2022​	4/2/2022​	5/1/2022​	Conflict	Conflict
Reorganization	10/1/2021​	9/30/2022​	9/30/2022​	10/5/2022​	Conflict	No Conflict
Reorganization	10/1/2021​	9/30/2022​	10/10/2022​	10/13/2022​	No Conflict	No Conflict
Reorganization	10/1/2021​	9/30/2022​	2/1/2025​	7/31/2025​	No Conflict	No Conflict
Reorganization	10/1/2021​	9/30/2022​	8/15/2022​	10/31/2022​	Conflict	No Conflict
Realignment	10/1/2021​	12/31/2021​	11/1/2023​	2/29/2024​	No Conflict	No Conflict
Realignment	10/1/2021​	12/31/2021​	12/1/2023​	1/4/2024​	No Conflict	No Conflict
Activation	10/1/2023​	9/30/2024​	10/1/2020​	10/31/2020​	No Conflict	No Conflict
Activation	10/1/2023​	9/30/2024​	9/26/2020​	10/31/2020​	No Conflict	No Conflict
Activation	10/1/2023​	9/30/2024​	9/26/2020​	10/31/2020​	No Conflict	No Conflict
Activation	10/1/2023​	9/30/2024​	9/26/2020​	10/31/2020​	No Conflict	No Conflict
Activation	10/1/2023​	9/30/2024​	9/26/2020​	10/31/2020​	No Conflict	No Conflict
Activation	10/1/2023​	9/30/2024​	9/26/2020​	10/31/2020​	No Conflict	No Conflict
Activation	10/1/2023​	9/30/2024​	9/26/2020​	10/31/2020​	No Conflict	No Conflict
Activation	10/1/2023​	9/30/2024​	9/1/2020​	10/31/2020​	No Conflict	No Conflict
Activation	10/1/2023​	9/30/2024​	9/1/2020​	9/20/2020​	No Conflict	No Conflict
Activation	10/1/2023​	9/30/2024​	9/1/2020​	9/20/2020​	No Conflict	No Conflict
Activation	10/1/2023​	9/30/2024​	9/1/2020​	9/20/2020​	No Conflict	No Conflict
Activation	10/1/2023​	9/30/2024​	9/1/2020​	9/20/2020​	No Conflict	No Conflict
Activation	10/1/2023​	9/30/2024​	9/1/2020​	10/31/2020​	No Conflict	No Conflict
Activation	10/1/2023​	9/30/2024​	9/1/2020​	10/31/2020​	No Conflict	No Conflict
Activation	10/1/2023​	9/30/2024​	9/1/2020​	10/31/2020​	No Conflict	No Conflict
Activation	10/1/2023​	9/30/2024​	9/1/2020​	10/31/2020​	No Conflict	No Conflict
Activation	10/1/2023​	9/30/2024​	9/1/2020​	9/20/2020​	No Conflict	No Conflict
Activation	10/1/2023​	9/30/2024​	9/26/2020​	10/31/2020​	No Conflict	No Conflict
Activation	10/1/2023​	9/30/2024​	9/26/2020​	10/31/2020​	No Conflict	No Conflict
Activation	10/1/2023​	9/30/2024​	9/1/2020​	10/31/2020​	No Conflict	No Conflict
Activation	10/1/2023​	9/30/2024​	9/26/2020​	10/31/2020​	No Conflict	No Conflict
Activation	10/1/2023​	9/30/2024​	9/1/2020​	10/31/2020​	No Conflict	No Conflict
Activation	10/1/2023​	9/30/2024​	1/15/2023​	7/14/2023​	No Conflict	No Conflict
Activation	10/1/2023​	9/30/2024​	3/1/2027​	8/28/2027​	No Conflict	No Conflict
Activation	10/1/2023​	9/30/2024​	2/1/2022​	5/20/2025​	No Conflict	No Conflict
Activation	10/1/2023​	9/30/2024​	1/1/2025​	6/30/2025​	No Conflict	No Conflict
Activation	10/1/2023​	9/30/2024​	8/16/2023​	2/12/2024​	No Conflict	Conflict
Activation	10/1/2023​	9/30/2024​	9/20/2022​	9/22/2022​	No Conflict	No Conflict
Activation	10/1/2023​	9/30/2024​	10/1/2025​	3/30/2026​	No Conflict	No Conflict
Activation	10/1/2025​	9/30/2026​	10/1/2020​	10/31/2020​	No Conflict	No Conflict
Activation	10/1/2025​	9/30/2026​	9/26/2020​	10/31/2020​	No Conflict	No Conflict
Activation	10/1/2025​	9/30/2026​	9/26/2020​	10/31/2020​	No Conflict	No Conflict
Activation	10/1/2025​	9/30/2026​	9/26/2020​	10/31/2020​	No Conflict	No Conflict
Activation	10/1/2025​	9/30/2026​	9/26/2020​	10/31/2020​	No Conflict	No Conflict
Activation	10/1/2025​	9/30/2026​	9/26/2020​	10/31/2020​	No Conflict	No Conflict
Activation	10/1/2025​	9/30/2026​	9/26/2020​	10/31/2020​	No Conflict	No Conflict
Activation	10/1/2025​	9/30/2026​	9/1/2020​	10/31/2020​	No Conflict	No Conflict
Activation	10/1/2025​	9/30/2026​	9/1/2020​	9/20/2020​	No Conflict	No Conflict
Activation	10/1/2025​	9/30/2026​	9/1/2020​	9/20/2020​	No Conflict	No Conflict
Activation	10/1/2025​	9/30/2026​	9/1/2020​	9/20/2020​	No Conflict	No Conflict
Activation	10/1/2025​	9/30/2026​	9/1/2020​	9/20/2020​	No Conflict	No Conflict
Activation	10/1/2025​	9/30/2026​	9/1/2020​	10/31/2020​	No Conflict	No Conflict
Activation	10/1/2025​	9/30/2026​	9/1/2020​	10/31/2020​	No Conflict	No Conflict
Activation	10/1/2025​	9/30/2026​	9/1/2020​	10/31/2020​	No Conflict	No Conflict
Activation	10/1/2025​	9/30/2026​	9/1/2020​	10/31/2020​	No Conflict	No Conflict
Activation	10/1/2025​	9/30/2026​	9/1/2020​	9/20/2020​	No Conflict	No Conflict
Activation	10/1/2025​	9/30/2026​	9/26/2020​	10/31/2020​	No Conflict	No Conflict
Activation	10/1/2025​	9/30/2026​	9/26/2020​	10/31/2020​	No Conflict	No Conflict
Activation	10/1/2025​	9/30/2026​	9/1/2020​	10/31/2020​	No Conflict	No Conflict
Activation	10/1/2025​	9/30/2026​	9/26/2020​	10/31/2020​	No Conflict	No Conflict
Activation	10/1/2025​	9/30/2026​	9/1/2020​	10/31/2020​	No Conflict	No Conflict
Activation	10/1/2025​	9/30/2026​	1/15/2023​	7/14/2023​	No Conflict	No Conflict
Activation	10/1/2025​	9/30/2026​	3/1/2027​	8/28/2027​	No Conflict	No Conflict
Activation	10/1/2025​	9/30/2026​	2/1/2022​	5/20/2025​	No Conflict	No Conflict
Activation	10/1/2025​	9/30/2026​	1/1/2025​	6/30/2025​	No Conflict	No Conflict
Activation	10/1/2025​	9/30/2026​	8/16/2023​	2/12/2024​	No Conflict	No Conflict
Activation	10/1/2025​	9/30/2026​	9/20/2022​	9/22/2022​	No Conflict	No Conflict
Activation	10/1/2025​	9/30/2026​	10/1/2025​	3/30/2026​	Conflict	Conflict
Reorganization	10/1/2027​	9/30/2028​	10/1/2020​	10/31/2020​	No Conflict	No Conflict
Reorganization	10/1/2027​	9/30/2028​	9/26/2020​	10/31/2020​	No Conflict	No Conflict
Reorganization	10/1/2027​	9/30/2028​	9/26/2020​	10/31/2020​	No Conflict	No Conflict
Reorganization	10/1/2027​	9/30/2028​	9/26/2020​	10/31/2020​	No Conflict	No Conflict
Reorganization	10/1/2027​	9/30/2028​	9/26/2020​	10/31/2020​	No Conflict	No Conflict
Reorganization	10/1/2027​	9/30/2028​	9/26/2020​	10/31/2020​	No Conflict	No Conflict
Reorganization	10/1/2027​	9/30/2028​	9/26/2020​	10/31/2020​	No Conflict	No Conflict
Reorganization	10/1/2027​	9/30/2028​	9/1/2020​	10/31/2020​	No Conflict	No Conflict
Reorganization	10/1/2027​	9/30/2028​	9/1/2020​	9/20/2020​	No Conflict	No Conflict
Reorganization	10/1/2027​	9/30/2028​	9/1/2020​	9/20/2020​	No Conflict	No Conflict
Reorganization	10/1/2027​	9/30/2028​	9/1/2020​	9/20/2020​	No Conflict	No Conflict
Reorganization	10/1/2027​	9/30/2028​	9/1/2020​	9/20/2020​	No Conflict	No Conflict
Reorganization	10/1/2027​	9/30/2028​	9/1/2020​	10/31/2020​	No Conflict	No Conflict
Reorganization	10/1/2027​	9/30/2028​	9/1/2020​	10/31/2020​	No Conflict	No Conflict
Reorganization	10/1/2027​	9/30/2028​	9/1/2020​	10/31/2020​	No Conflict	No Conflict
Reorganization	10/1/2027​	9/30/2028​	9/1/2020​	10/31/2020​	No Conflict	No Conflict
Reorganization	10/1/2027​	9/30/2028​	9/1/2020​	9/20/2020​	No Conflict	No Conflict
Reorganization	10/1/2027​	9/30/2028​	9/26/2020​	10/31/2020​	No Conflict	No Conflict
Reorganization	10/1/2027​	9/30/2028​	9/26/2020​	10/31/2020​	No Conflict	No Conflict
Reorganization	10/1/2027​	9/30/2028​	9/1/2020​	10/31/2020​	No Conflict	No Conflict
Reorganization	10/1/2027​	9/30/2028​	9/26/2020​	10/31/2020​	No Conflict	No Conflict
Reorganization	10/1/2027​	9/30/2028​	9/1/2020​	10/31/2020​	No Conflict	No Conflict
Reorganization	10/1/2027​	9/30/2028​	1/15/2023​	7/14/2023​	No Conflict	No Conflict
Reorganization	10/1/2027​	9/30/2028​	3/1/2027​	8/28/2027​	No Conflict	No Conflict
Reorganization	10/1/2027​	9/30/2028​	2/1/2022​	5/20/2025​	No Conflict	No Conflict
Reorganization	10/1/2027​	9/30/2028​	1/1/2025​	6/30/2025​	No Conflict	No Conflict
Reorganization	10/1/2027​	9/30/2028​	8/16/2023​	2/12/2024​	No Conflict	No Conflict
Reorganization	10/1/2027​	9/30/2028​	9/20/2022​	9/22/2022​	No Conflict	No Conflict
Reorganization	10/1/2027​	9/30/2028​	10/1/2025​	3/30/2026​	No Conflict	No Conflict
Reorganization	10/1/2023​	9/30/2024​	10/1/2023​	3/29/2024​	Conflict	Conflict
Reorganization	10/1/2023​	9/30/2024​	11/1/2021​	2/28/2022​	No Conflict	No Conflict
Reorganization	10/1/2023​	9/30/2024​	9/6/2022​	3/16/2023​	No Conflict	No Conflict
Reorganization	10/1/2021​	9/30/2022​	1/1/2023​	6/30/2023​	No Conflict	No Conflict
Reorganization	10/1/2021​	9/30/2022​	11/1/2022​	3/7/2024​	No Conflict	No Conflict
Reorganization	10/1/2021​	9/30/2022​	4/15/2021​	6/23/2023​	No Conflict	No Conflict
Reorganization	10/1/2021​	9/30/2022​	11/1/2022​	5/1/2024​	No Conflict	No Conflict
Reorganization	10/1/2021​	9/30/2022​	1/3/2022​	9/30/2022​	Conflict	Conflict
Reorganization	10/1/2022​	9/30/2023​	1/13/2025​	4/14/2025​	No Conflict	No Conflict
Reorganization	10/1/2022​	9/30/2023​	1/1/2024​	6/29/2024​	No Conflict	No Conflict
Reorganization	10/1/2022​	9/30/2023​	12/1/2024​	3/1/2025​	No Conflict	No Conflict
Reorganization	7/1/2024​	10/1/2024​	10/1/2023​	12/30/2023​	No Conflict	No Conflict
Activation	10/1/2021​	12/31/2021​	9/6/2022​	3/16/2023​	No Conflict	No Conflict
Activation	10/1/2021​	12/31/2021​	11/30/2022​	2/1/2023​	No Conflict	No Conflict
Activation	2/1/2022​	8/1/2022​	9/6/2022​	3/16/2023​	No Conflict	No Conflict
Activation	2/1/2022​	8/1/2022​	11/30/2022​	2/1/2023​	No Conflict	No Conflict
Realignment	1/2/2026​	12/31/2026​	9/6/2022​	3/16/2023​	No Conflict	No Conflict
Realignment	1/2/2026​	12/31/2026​	11/30/2022​	2/1/2023​	No Conflict	No Conflict
Reorganization	1/1/2024​	12/1/2024​	9/6/2022​	3/16/2023​	No Conflict	No Conflict
Reorganization	1/1/2024​	12/1/2024​	11/30/2022​	2/1/2023​	No Conflict	No Conflict
Realignment	1/2/2026​	12/31/2026​	9/6/2022​	3/16/2023​	No Conflict	No Conflict
Realignment	1/2/2026​	12/31/2026​	11/30/2022​	2/1/2023​	No Conflict	No Conflict
Activation	7/1/2020​	7/31/2020​	9/26/2020​	10/31/2020​	No Conflict	No Conflict
Activation	7/1/2020​	7/31/2020​	9/1/2020​	10/31/2020​	No Conflict	No Conflict
Activation	7/1/2020​	7/31/2020​	9/1/2020​	10/31/2020​	No Conflict	No Conflict
Activation	7/1/2020​	7/31/2020​	9/26/2020​	10/31/2020​	No Conflict	No Conflict
Activation	7/1/2020​	7/31/2020​	9/1/2020​	10/31/2020​	No Conflict	No Conflict
Activation	7/1/2020​	7/31/2020​	1/1/2020​	12/26/2020​	No Conflict	No Conflict
Activation	7/1/2020​	7/31/2020​	1/1/2024​	3/29/2024​	No Conflict	No Conflict
Activation	7/1/2020​	7/31/2020​	2/1/2022​	5/20/2025​	No Conflict	No Conflict
Activation	7/1/2020​	7/31/2020​	9/1/2022​	3/8/2023​	No Conflict	No Conflict
Activation	7/1/2020​	7/31/2020​	7/20/2022​	3/16/2023​	No Conflict	No Conflict
Activation	7/1/2020​	7/31/2020​	9/6/2022​	3/16/2023​	No Conflict	No Conflict
Activation	7/1/2020​	7/31/2020​	9/13/2022​	9/22/2022​	No Conflict	No Conflict
Activation	7/1/2020​	7/31/2020​	12/1/2021​	1/26/2022​	No Conflict	No Conflict
Reorganization	10/1/2022​	9/30/2023​	1/12/2025​	4/13/2025​	No Conflict	No Conflict
Reorganization	10/1/2023​	9/30/2024​	1/13/2025​	4/13/2025​	No Conflict	No Conflict
Reorganization	10/1/2023​	9/30/2024​	4/1/2022​	4/1/2023​	No Conflict	No Conflict
Reorganization	10/1/2023​	9/30/2024​	12/1/2022​	3/16/2023​	No Conflict	No Conflict
Activation	6/1/2022​	6/15/2022​	1/9/2023​	6/26/2025​	No Conflict	No Conflict
Activation	6/1/2022​	6/15/2022​	6/1/2022​	10/9/2022​	Conflict	No Conflict
Activation	6/1/2022​	6/15/2022​	6/1/2022​	10/9/2022​	Conflict	No Conflict
Reorganization	10/1/2023​	2/1/2024​	7/1/2024​	9/29/2024​	No Conflict	No Conflict
Reorganization	5/1/2026​	2/1/2027​	7/4/2025​	12/31/2025​	No Conflict	No Conflict
Realignment	5/1/2025​	10/1/2025​	6/1/2023​	11/28/2023​	No Conflict	No Conflict
Deactivation	10/1/2026​	3/1/2027​	2/1/2024​	7/31/2024​	No Conflict	No Conflict
Reorganization	1/1/2024​	6/1/2024​	5/1/2025​	10/28/2025​	No Conflict	No Conflict
Activation	7/1/2021​	7/15/2021​	4/1/2022​	5/21/2022​	No Conflict	No Conflict
Activation	7/1/2021​	7/15/2021​	4/1/2022​	4/5/2022​	No Conflict	No Conflict
Activation	7/1/2021​	7/15/2021​	4/1/2022​	5/21/2022​	No Conflict	No Conflict
Activation	7/1/2021​	7/15/2021​	4/27/2022​	4/30/2022​	No Conflict	No Conflict
Activation	7/1/2021​	7/15/2021​	4/27/2022​	5/21/2022​	No Conflict	No Conflict
Activation	7/1/2021​	7/15/2021​	4/1/2022​	5/21/2022​	No Conflict	No Conflict
Activation	7/1/2021​	7/15/2021​	4/1/2022​	5/21/2022​	No Conflict	No Conflict
Activation	7/1/2021​	7/15/2021​	4/1/2022​	5/21/2022​	No Conflict	No Conflict
Activation	7/1/2021​	7/15/2021​	4/1/2022​	4/4/2022​	No Conflict	No Conflict
Activation	7/1/2021​	7/15/2021​	4/1/2022​	5/21/2022​	No Conflict	No Conflict
Activation	7/1/2021​	7/15/2021​	4/1/2022​	5/21/2022​	No Conflict	No Conflict
Activation	7/1/2021​	7/15/2021​	4/5/2022​	5/21/2022​	No Conflict	No Conflict
Activation	7/1/2021​	7/15/2021​	4/1/2022​	5/21/2022​	No Conflict	No Conflict
Activation	11/1/2021​	11/30/2021​	10/1/2021​	10/30/2021​	No Conflict	No Conflict
Activation	9/1/2022​	11/1/2022​	6/1/2022​	7/22/2022​	No Conflict	No Conflict
Realignment	2/1/2022​	2/5/2022​	10/1/2023​	3/29/2024​	No Conflict	No Conflict
Realignment	2/1/2022​	2/5/2022​	6/1/2029​	8/10/2029​	No Conflict	No Conflict
Realignment	2/1/2022​	2/5/2022​	6/1/2029​	12/3/2029​	No Conflict	No Conflict
Realignment	2/1/2022​	2/5/2022​	10/1/2022​	12/1/2022​	No Conflict	No Conflict
Realignment	2/1/2022​	2/5/2022​	1/1/2029​	4/1/2029​	No Conflict	No Conflict
Realignment	2/1/2022​	2/5/2022​	1/1/2022​	1/31/2022​	No Conflict	No Conflict
Realignment	2/1/2022​	2/5/2022​	1/1/2022​	1/31/2022​	No Conflict	No Conflict
Realignment	2/1/2022​	2/5/2022​	12/22/2021​	2/1/2022​	No Conflict	Conflict
Realignment	2/1/2022​	2/5/2022​	12/21/2021​	2/2/2022​	No Conflict	Conflict
Realignment	2/1/2022​	2/5/2022​	12/1/2021​	2/28/2022​	No Conflict	No Conflict
Realignment	2/1/2022​	2/5/2022​	12/1/2021​	2/28/2022​	No Conflict	No Conflict
Realignment	2/1/2022​	2/5/2022​	1/1/2022​	1/31/2022​	No Conflict	No Conflict
Realignment	2/1/2022​	2/5/2022​	12/15/2021​	1/15/2022​	No Conflict	No Conflict
Realignment	2/1/2022​	2/5/2022​	1/26/2022​	2/28/2022​	No Conflict	No Conflict
Realignment	2/1/2022​	2/5/2022​	12/1/2021​	2/28/2022​	No Conflict	No Conflict
Realignment	2/1/2022​	2/5/2022​	1/1/2022​	1/31/2022​	No Conflict	No Conflict
Realignment	2/1/2022​	2/5/2022​	1/12/2022​	2/2/2022​	No Conflict	Conflict
Realignment	2/1/2022​	2/5/2022​	1/20/2022​	2/28/2022​	No Conflict	No Conflict
Reorganization	10/1/2022​	11/1/2022​	10/1/2023​	3/29/2024​	No Conflict	No Conflict
Reorganization	10/1/2022​	11/1/2022​	6/1/2029​	8/10/2029​	No Conflict	No Conflict
Reorganization	10/1/2022​	11/1/2022​	6/1/2029​	12/3/2029​	No Conflict	No Conflict
Reorganization	10/1/2022​	11/1/2022​	10/1/2022​	12/1/2022​	Conflict	No Conflict
Reorganization	10/1/2022​	11/1/2022​	1/1/2029​	4/1/2029​	No Conflict	No Conflict
Reorganization	10/1/2022​	11/1/2022​	1/1/2022​	1/31/2022​	No Conflict	No Conflict
Reorganization	10/1/2022​	11/1/2022​	1/1/2022​	1/31/2022​	No Conflict	No Conflict
Reorganization	10/1/2022​	11/1/2022​	12/22/2021​	2/1/2022​	No Conflict	No Conflict
Reorganization	10/1/2022​	11/1/2022​	12/21/2021​	2/2/2022​	No Conflict	No Conflict
Reorganization	10/1/2022​	11/1/2022​	12/1/2021​	2/28/2022​	No Conflict	No Conflict
Reorganization	10/1/2022​	11/1/2022​	12/1/2021​	2/28/2022​	No Conflict	No Conflict
Reorganization	10/1/2022​	11/1/2022​	1/1/2022​	1/31/2022​	No Conflict	No Conflict
Reorganization	10/1/2022​	11/1/2022​	12/15/2021​	1/15/2022​	No Conflict	No Conflict
Reorganization	10/1/2022​	11/1/2022​	1/26/2022​	2/28/2022​	No Conflict	No Conflict
Reorganization	10/1/2022​	11/1/2022​	12/1/2021​	2/28/2022​	No Conflict	No Conflict
Reorganization	10/1/2022​	11/1/2022​	1/1/2022​	1/31/2022​	No Conflict	No Conflict
Reorganization	10/1/2022​	11/1/2022​	1/12/2022​	2/2/2022​	No Conflict	No Conflict
Reorganization	10/1/2022​	11/1/2022​	1/20/2022​	2/28/2022​	No Conflict	No Conflict
Activation	1/1/2022​	1/31/2022​	9/1/2023​	10/1/2023​	No Conflict	No Conflict
Realignment	2/1/2022​	2/5/2022​	9/1/2023​	10/1/2023​	No Conflict	No Conflict
Activation	12/1/2021​	1/15/2022​	9/1/2023​	10/1/2023​	No Conflict	No Conflict
Activation	7/1/2021​	7/31/2021​	6/1/2029​	9/24/2029​	No Conflict	No Conflict
Activation	7/1/2021​	7/31/2021​	6/1/2029​	10/29/2029​	No Conflict	No Conflict
Activation	7/1/2021​	7/31/2021​	10/1/2022​	12/1/2022​	No Conflict	No Conflict
Activation	7/1/2021​	7/31/2021​	1/1/2023​	1/31/2024​	No Conflict	No Conflict
Activation	7/1/2021​	7/31/2021​	1/1/2023​	1/31/2024​	No Conflict	No Conflict
Reorganization	10/1/2022​	11/1/2022​	6/1/2029​	9/24/2029​	No Conflict	No Conflict
Reorganization	10/1/2022​	11/1/2022​	6/1/2029​	10/29/2029​	No Conflict	No Conflict
Reorganization	10/1/2022​	11/1/2022​	10/1/2022​	12/1/2022​	Conflict	No Conflict
Reorganization	10/1/2022​	11/1/2022​	1/1/2023​	1/31/2024​	No Conflict	No Conflict
Reorganization	10/1/2022​	11/1/2022​	1/1/2023​	1/31/2024​	No Conflict	No Conflict
Activation	12/1/2021​	2/1/2022​	1/1/2022​	3/31/2022​	Conflict	No Conflict
Activation	12/1/2021​	2/1/2022​	12/9/2021​	3/31/2022​	Conflict	No Conflict
Activation	12/1/2021​	2/1/2022​	1/1/2022​	3/31/2022​	Conflict	No Conflict
Activation	12/1/2021​	2/1/2022​	1/1/2022​	3/31/2022​	Conflict	No Conflict
Activation	12/1/2021​	2/1/2022​	1/1/2022​	3/31/2022​	Conflict	No Conflict
Activation	12/1/2021​	2/1/2022​	12/8/2021​	12/9/2021​	Conflict	Conflict
Activation	12/1/2021​	2/1/2022​	12/9/2021​	3/31/2022​	Conflict	No Conflict
Activation	12/1/2021​	2/1/2022​	12/9/2021​	3/31/2022​	Conflict	No Conflict
Activation	12/1/2021​	2/1/2022​	12/9/2021​	3/31/2022​	Conflict	No Conflict
Activation	12/1/2021​	2/1/2022​	12/9/2021​	3/31/2022​	Conflict	No Conflict
Activation	12/1/2021​	2/1/2022​	12/9/2021​	3/31/2022​	Conflict	No Conflict
Activation	12/1/2021​	2/1/2022​	12/8/2021​	12/9/2021​	Conflict	Conflict
Activation	12/1/2021​	2/1/2022​	12/10/2021​	12/12/2021​	Conflict	Conflict
Activation	12/1/2021​	2/1/2022​	1/1/2022​	3/31/2022​	Conflict	No Conflict
Activation	12/1/2021​	2/1/2022​	12/10/2021​	12/12/2021​	Conflict	Conflict
Activation	12/1/2021​	2/1/2022​	12/10/2021​	3/31/2022​	Conflict	No Conflict
Activation	12/1/2021​	2/1/2022​	12/10/2021​	3/31/2022​	Conflict	No Conflict
Activation	12/1/2021​	2/1/2022​	1/1/2022​	3/31/2022​	Conflict	No Conflict
Activation	12/1/2021​	2/1/2022​	12/10/2021​	3/31/2022​	Conflict	No Conflict
Activation	12/1/2021​	2/1/2022​	12/10/2021​	3/31/2022​	Conflict	No Conflict
Activation	12/1/2021​	2/1/2022​	12/10/2021​	3/31/2022​	Conflict	No Conflict
Activation	12/1/2021​	2/1/2022​	12/10/2021​	3/31/2022​	Conflict	No Conflict
Activation	12/1/2021​	2/1/2022​	12/10/2021​	3/31/2022​	Conflict	No Conflict
Activation	12/1/2021​	2/1/2022​	12/10/2021​	3/31/2022​	Conflict	No Conflict
Activation	12/1/2021​	2/1/2022​	1/1/2022​	3/31/2022​	Conflict	No Conflict
Activation	12/1/2021​	2/1/2022​	1/1/2022​	3/31/2022​	Conflict	No Conflict
Activation	12/1/2021​	2/1/2022​	12/10/2021​	12/12/2021​	Conflict	Conflict
Activation	12/1/2021​	2/1/2022​	1/1/2022​	3/31/2022​	Conflict	No Conflict
Activation	12/1/2021​	2/1/2022​	1/1/2022​	3/31/2022​	Conflict	No Conflict
Activation	12/1/2021​	2/1/2022​	1/1/2022​	3/31/2022​	Conflict	No Conflict
Activation	12/1/2021​	2/1/2022​	1/1/2022​	3/31/2022​	Conflict	No Conflict
Activation	12/1/2021​	2/1/2022​	1/1/2022​	3/31/2022​	Conflict	No Conflict
Activation	12/1/2021​	2/1/2022​	1/1/2022​	3/31/2022​	Conflict	No Conflict
Activation	12/1/2021​	2/1/2022​	1/1/2022​	3/31/2022​	Conflict	No Conflict
Activation	12/1/2021​	2/1/2022​	1/1/2022​	3/31/2022​	Conflict	No Conflict
Activation	12/1/2021​	2/1/2022​	1/1/2022​	3/31/2022​	Conflict	No Conflict
Activation	12/1/2021​	2/1/2022​	1/1/2022​	3/31/2022​	Conflict	No Conflict
Reorganization	11/1/2021​	11/30/2021​	10/1/2021​	1/31/2022​	No Conflict	No Conflict
Reorganization	11/1/2021​	11/30/2021​	11/15/2021​	12/15/2021​	Conflict	No Conflict
Reorganization	11/1/2021​	11/30/2021​	10/1/2021​	1/31/2022​	No Conflict	No Conflict
Realignment	11/1/2021​	11/30/2021​	10/1/2021​	1/31/2022​	No Conflict	No Conflict
Realignment	11/1/2021​	11/30/2021​	10/1/2021​	1/31/2022​	No Conflict	No Conflict
Realignment	11/1/2021​	11/30/2021​	10/1/2021​	10/30/2021​	No Conflict	No Conflict
Realignment	11/1/2021​	11/30/2021​	10/1/2021​	1/1/2023​	No Conflict	No Conflict
Realignment	11/1/2021​	11/30/2021​	10/1/2021​	1/31/2022​	No Conflict	No Conflict
Realignment	11/1/2021​	11/30/2021​	10/6/2021​	1/4/2022​	No Conflict	No Conflict
Realignment	11/1/2021​	11/30/2021​	10/1/2021​	1/31/2022​	No Conflict	No Conflict
Realignment	11/1/2021​	11/30/2021​	10/1/2021​	1/31/2022​	No Conflict	No Conflict
Realignment	11/1/2021​	11/30/2021​	10/1/2021​	1/31/2022​	No Conflict	No Conflict
Realignment	11/1/2021​	11/30/2021​	1/1/2023​	1/1/2024​	No Conflict	No Conflict
Realignment	11/1/2021​	11/30/2021​	10/1/2021​	1/31/2022​	No Conflict	No Conflict
Realignment	11/1/2021​	11/30/2021​	10/1/2021​	1/31/2022​	No Conflict	No Conflict
Activation	2/1/2022​	4/1/2022​	12/5/2021​	1/24/2022​	No Conflict	No Conflict
Activation	2/1/2022​	4/1/2022​	12/5/2021​	1/24/2022​	No Conflict	No Conflict
Activation	2/1/2022​	4/1/2022​	12/5/2021​	1/24/2022​	No Conflict	No Conflict
Activation	11/1/2021​	11/30/2021​	11/10/2021​	11/30/2021​	Conflict	Conflict
Activation	11/1/2021​	11/30/2021​	10/1/2021​	1/31/2022​	No Conflict	No Conflict
Deactivation	11/1/2021​	11/30/2021​	1/1/2022​	1/31/2022​	No Conflict	No Conflict
Deactivation	11/1/2021​	11/30/2021​	10/1/2021​	1/31/2022​	No Conflict	No Conflict
Reorganization	11/1/2021​	11/30/2021​	1/1/2022​	1/31/2022​	No Conflict	No Conflict
Reorganization	11/1/2021​	11/30/2021​	10/1/2021​	1/31/2022​	No Conflict	No Conflict
Realignment	11/1/2021​	11/30/2021​	1/1/2022​	1/31/2022​	No Conflict	No Conflict
Realignment	11/1/2021​	11/30/2021​	10/1/2021​	1/31/2022​	No Conflict	No Conflict
Realignment	11/1/2021​	11/30/2021​	9/1/2021​	10/1/2021​	No Conflict	No Conflict
Realignment	11/1/2021​	11/30/2021​	1/1/2022​	1/31/2022​	No Conflict	No Conflict
Realignment	11/1/2021​	11/30/2021​	10/1/2021​	1/31/2022​	No Conflict	No Conflict
Reorganization	12/1/2021​	2/1/2022​	1/1/2022​	3/31/2022​	Conflict	No Conflict
Reorganization	12/31/2021​	4/1/2022​	1/1/2022​	3/31/2022​	Conflict	Conflict

 

[ExceLoki]

try this

=IF(AND(IF(D2>=$B2,IF(D2<=$C2,"Conflict","No Conflict"),"No Conflict")="No Conflict",IF(E2>=$B2,IF(E2<=$C2,"Conflict","No Conflict"),"No Conflict")="No Conflict"),"No Conflict",A2)

it combines your 2 formulas into one. if both are no conflict then returns no conflict, but if either is conflict, then it returns the value from column a.
let me know if this works for what you need