Forum Discussion
Solved
IF AND OR formula regarding Start Dates and End Dates
Hi everyone, I want to achieve an outcome where I only include accounts which: If Date Closed (column A) OR Date Deferred (column B) is between Start Date and End Date in 2019 OR 2020, then c...
JennyHoA20181
Try if this works for you=IF(OR(AND(A2>=$F$2,A2<=$F$3),AND(A2>=$G$2,A2<=$G$3),AND(B2>=$F$2,B2<=$F$3),AND(B2>=$G$2,B2<=$G$3)),"INCLUDE","")
I have included both the start and end dates in the formula
Another variant
=IF( (MEDIAN(A2,$F$2:$F$3)=A2)+(MEDIAN(A2,$G$2:$G$3)=A2),"INCLUDE","")- This is fantastic - thank you!
Glad to help
