Forum Discussion
Solved
Find if a date contained in one range is present in another range
I am trying to create a formula with a yes/no type outcome for the attached problem. I have 2 date ranges and I want to know if any of the dates in the first range are contained within the second ra...
Felicity123 I believe this formula should work as desired:
=IF(OR(AND(B1<B2,C1<B2),AND(B1>C2,C1>C2)),"No","Yes")
Felicity123 I believe this formula should work as desired:
=IF(OR(AND(B1<B2,C1<B2),AND(B1>C2,C1>C2)),"No","Yes")
- Thank you! Works perfectly!
