apj101
VIP Member
=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>=VLOOKUP($H36,Holidays,6,0),BJ$29<=VLOOKUP($H36,Holidays,7,0)),1,0),0), IF($Q36="All",IF(AND(BJ$29>=VLOOKUP($H36,Holidays,8,0),BJ$29<=VLOOKUP($H36,Holidays,9,0)),1,0),0),IF($Q36="All",IF(AND(BJ$29>=VLOOKUP($H36,Holidays,10,0),BJ$29<=VLOOKUP($H36,Holidays,11,0)),1,0),0))),IF(OR(IF(ISERROR(VLOOKUP($I36,Holidays,1,0))=TRUE,1,0),LEN($I36)=0),0,OR(IF($Q36="All",IF(AND(BJ$29>=VLOOKUP($I36,Holidays,2,0),BJ$29<=VLOOKUP($I36,Holidays,3,0)),1,0),0),IF($Q36="All",IF(AND(BJ$29>=VLOOKUP($I36,Holidays,4,0),BJ$29<=VLOOKUP($I36,Holidays,5,0)),1,0),0),IF($Q36="All",IF(AND(BJ$29>=VLOOKUP($I36,Holidays,6,0),BJ$29<=VLOOKUP($I36,Holidays,7,0)),1,0),0), IF($Q36="All",IF(AND(BJ$29>=VLOOKUP($I36,Holidays,8,0),BJ$29<=VLOOKUP($I36,Holidays,9,0)),1,0),0),IF($Q36="All",IF(AND(BJ$29>=VLOOKUP($I36,Holidays,10,0),BJ$29<=VLOOKUP($I36,Holidays,11,0)),1,0),0))),IF(OR(IF(ISERROR(VLOOKUP($J36,Holidays,1,0))=TRUE,1,0),LEN($J36)=0),0,OR(IF($Q36="All",IF(AND(BJ$29>=VLOOKUP($J36,Holidays,2,0),BJ$29<=VLOOKUP($J36,Holidays,3,0)),1,0),0),IF($Q36="All",IF(AND(BJ$29>=VLOOKUP($J36,Holidays,4,0),BJ$29<=VLOOKUP($J36,Holidays,5,0)),1,0),0),IF($Q36="All",IF(AND(BJ$29>=VLOOKUP($J36,Holidays,6,0),BJ$29<=VLOOKUP($J36,Holidays,7,0)),1,0),0), IF($Q36="All",IF(AND(BJ$29>=VLOOKUP($J36,Holidays,8,0),BJ$29<=VLOOKUP($J36,Holidays,9,0)),1,0),0),IF($Q36="All",IF(AND(BJ$29>=VLOOKUP($J36,Holidays,10,0),BJ$29<=VLOOKUP($J36,Holidays,11,0)),1,0),0))),IF(OR(IF(ISERROR(VLOOKUP($K36,Holidays,1,0))=TRUE,1,0),LEN($K36)=0),0,OR(IF($Q36="All",IF(AND(BJ$29>=VLOOKUP($K36,Holidays,2,0),BJ$29<=VLOOKUP($K36,Holidays,3,0)),1,0),0),IF($Q36="All",IF(AND(BJ$29>=VLOOKUP($K36,Holidays,4,0),BJ$29<=VLOOKUP($K36,Holidays,5,0)),1,0),0),IF($Q36="All",IF(AND(BJ$29>=VLOOKUP($K36,Holidays,6,0),BJ$29<=VLOOKUP($K36,Holidays,7,0)),1,0),0), IF($Q36="All",IF(AND(BJ$29>=VLOOKUP($K36,Holidays,8,0),BJ$29<=VLOOKUP($K36,Holidays,9,0)),1,0),0),IF($Q36="All",IF(AND(BJ$29>=VLOOKUP($K36,Holidays,10,0),BJ$29<=VLOOKUP($K36,Holidays,11,0)),1,0),0))),IF(OR(IF(ISERROR(VLOOKUP($L36,Holidays,1,0))=TRUE,1,0),LEN($L36)=0),0,OR(IF($Q36="All",IF(AND(BJ$29>=VLOOKUP($L36,Holidays,2,0),BJ$29<=VLOOKUP($L36,Holidays,3,0)),1,0),0),IF($Q36="All",IF(AND(BJ$29>=VLOOKUP($L36,Holidays,4,0),BJ$29<=VLOOKUP($L36,Holidays,5,0)),1,0),0),IF($Q36="All",IF(AND(BJ$29>=VLOOKUP($L36,Holidays,6,0),BJ$29<=VLOOKUP($L36,Holidays,7,0)),1,0),0), IF($Q36="All",IF(AND(BJ$29>=VLOOKUP($L36,Holidays,8,0),BJ$29<=VLOOKUP($L36,Holidays,9,0)),1,0),0),IF($Q36="All",IF(AND(BJ$29>=VLOOKUP($L36,Holidays,10,0),BJ$29<=VLOOKUP($L36,Holidays,11,0)),1,0),0))),IF(OR(IF(ISERROR(VLOOKUP($M36,Holidays,1,0))=TRUE,1,0),LEN($M36)=0),0,OR(IF($Q36="All",IF(AND(BJ$29>=VLOOKUP($M36,Holidays,2,0),BJ$29<=VLOOKUP($M36,Holidays,3,0)),1,0),0),IF($Q36="All",IF(AND(BJ$29>=VLOOKUP($M36,Holidays,4,0),BJ$29<=VLOOKUP($M36,Holidays,5,0)),1,0),0),IF($Q36="All",IF(AND(BJ$29>=VLOOKUP($M36,Holidays,6,0),BJ$29<=VLOOKUP($M36,Holidays,7,0)),1,0),0), IF($Q36="All",IF(AND(BJ$29>=VLOOKUP($M36,Holidays,8,0),BJ$29<=VLOOKUP($M36,Holidays,9,0)),1,0),0),IF($Q36="All",IF(AND(BJ$29>=VLOOKUP($M36,Holidays,10,0),BJ$29<=VLOOKUP($M36,Holidays,11,0)),1,0),0)))),1,0)
word!
word!