Forum Discussion

JennyHoA20181's avatar
JennyHoA20181
Brass Contributor
Jun 02, 2020
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...
excel
Excel on Mac
Formulas and Functions
  • saybhatt's avatar
    saybhatt
    Jun 02, 2020

    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's avatar
JennyHoA20181
Brass Contributor
Jun 03, 2020
This is fantastic - thank you!

Resources