I have the following formula that is not returning a value.
=IFERROR(IF(AND(D79>1,(WEEKDAY(D79)=2)),(INDEX(Holidays!$G$2:$G$183,MATCH(TRUE,INDEX(Holidays!$G$2:$G$183>(D79+2),0),))),IF(AND(D79>1,(WEEKDAY(D79)=3)),(INDEX(Holidays!$G$2:$G$183,MATCH(TRUE,INDEX(Holidays!$G$2:$G$183>(D79+6),0),))),IF(AND(D79>1,(WEEKDAY(D79)=4)),(INDEX(Holidays!$G$2:$G$183,MATCH(TRUE,INDEX(Holidays!$G$2:$G$183>(D79+5),0),))),IF(AND(D79>1,(WEEKDAY(D79)=5)),(INDEX(Holidays!$G$2:$G$183,MATCH(TRUE,INDEX(Holidays!$G$2:$G$183>(D79+4),0),))),IF(AND(D79>1,(WEEKDAY(D79)=6)),(INDEX(Holidays!$G$2:$G$183,MATCH(TRUE,INDEX(Holidays!$G$2:$G$183>(D79+5),0),))),IF(AND(D79=””,(WEEKDAY(D78)=2)),(INDEX(Holidays!$G$2:$G$183,MATCH(TRUE,INDEX(Holidays!$G$2:$G$183>(D78+2),0),))),IF(AND(D79=””,(WEEKDAY(D78)=3)),(INDEX(Holidays!$G$2:$G$183,MATCH(TRUE,INDEX(Holidays!$G$2:$G$183>(D78+6),0),))),IF(AND(D79="",(WEEKDAY(D78)=4)),(INDEX(Holidays!$G$2:$G$183,MATCH(TRUE,INDEX(Holidays!$G$2:$G$183>(D78+5),0),))),IF(AND(D79=””,(WEEKDAY(D78)=5)),(INDEX(Holidays!$G$2:$G$183,MATCH(TRUE,INDEX(Holidays!$G$2:$G$183>(D78+4),0),))),IF(AND(D79=””,(WEEKDAY(D78)=6)),(INDEX(Holidays!$G$2:$G$183,MATCH(TRUE,INDEX(Holidays!$G$2:$G$183>(D78+5),0),))))))))))))),"")
But when I break the formula in half and only do either the conditions of D79>1 or D79="" the formula works. I just can't seem to get them to work when adding them together.
Anyone see why this wouldn't return a value?
=IFERROR(IF(AND(D79>1,(WEEKDAY(D79)=2)),(INDEX(Holidays!$G$2:$G$183,MATCH(TRUE,INDEX(Holidays!$G$2:$G$183>(D79+2),0),))),IF(AND(D79>1,(WEEKDAY(D79)=3)),(INDEX(Holidays!$G$2:$G$183,MATCH(TRUE,INDEX(Holidays!$G$2:$G$183>(D79+6),0),))),IF(AND(D79>1,(WEEKDAY(D79)=4)),(INDEX(Holidays!$G$2:$G$183,MATCH(TRUE,INDEX(Holidays!$G$2:$G$183>(D79+5),0),))),IF(AND(D79>1,(WEEKDAY(D79)=5)),(INDEX(Holidays!$G$2:$G$183,MATCH(TRUE,INDEX(Holidays!$G$2:$G$183>(D79+4),0),))),IF(AND(D79>1,(WEEKDAY(D79)=6)),(INDEX(Holidays!$G$2:$G$183,MATCH(TRUE,INDEX(Holidays!$G$2:$G$183>(D79+5),0),))),IF(AND(D79=””,(WEEKDAY(D78)=2)),(INDEX(Holidays!$G$2:$G$183,MATCH(TRUE,INDEX(Holidays!$G$2:$G$183>(D78+2),0),))),IF(AND(D79=””,(WEEKDAY(D78)=3)),(INDEX(Holidays!$G$2:$G$183,MATCH(TRUE,INDEX(Holidays!$G$2:$G$183>(D78+6),0),))),IF(AND(D79="",(WEEKDAY(D78)=4)),(INDEX(Holidays!$G$2:$G$183,MATCH(TRUE,INDEX(Holidays!$G$2:$G$183>(D78+5),0),))),IF(AND(D79=””,(WEEKDAY(D78)=5)),(INDEX(Holidays!$G$2:$G$183,MATCH(TRUE,INDEX(Holidays!$G$2:$G$183>(D78+4),0),))),IF(AND(D79=””,(WEEKDAY(D78)=6)),(INDEX(Holidays!$G$2:$G$183,MATCH(TRUE,INDEX(Holidays!$G$2:$G$183>(D78+5),0),))))))))))))),"")
But when I break the formula in half and only do either the conditions of D79>1 or D79="" the formula works. I just can't seem to get them to work when adding them together.
Anyone see why this wouldn't return a value?