=IF(OR(IF(OR(IF(ISERROR(VLOOKUP($H36,Holidays,1,0))=TRUE,1,0)),0,OR(IF($Q36="All",IF(AND(BJ$29>=VLOOKUP($H36,Holidays,2,0),BJ$29<=VLOOKUP($H36,Holidays,3,0)),1,0),0),IF($Q36="All",IF(AND(BJ$29>=VLOOKUP($H36,Holidays,4,0),BJ$29<=VLOOKUP($H36,Holidays,5,0)),1,0),0),IF($Q36="All",IF(AND(BJ$29>=VLOOK...