Formula is not producing a result

[raysha22]

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?

 

[Fluff]

You have some sloping quotes ” in there, they should all be vertical quotes "

 

[raysha22]

OMG I can't believe I missed those! Thanks for pointing them out That fixed it.

 

[Fluff]

You're welcome & thanks for the feedback.
Looking at your formula you might be able to simplify it like

=IFERROR(IF(AND(D79>1,WEEKDAY(D79,2)<6),INDEX(Holidays!$G$2:$G$183,MATCH(TRUE,INDEX(Holidays!$G$2:$G$183>(D79+choose(WEEKDAY(d79,2),2,6,5,4,5)),0),)),if(and(d79="",weekday(d78)>1),...