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
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
Amazing! thank you so much and for super quick response!