Workday Question

[francoiscj1]

I'm having problems with the following formula and can't figure out why I keep getting an error:

=IFERROR(IF(OR(ISNUMBER(SEARCH("Expedite",D4)),ISNUMBER(SEARCH("Urgent",D4))),i4,WORKDAY(MAX(IF(ISNUMBER(I4),I4,H4),J4,K4,L4,M4),IF(G4="Annual",WORKDAY(EDATE(I4,12),1,Control!$A$1:$A$13),IF(G4="Every 2 Years",WORKDAY(EDATE(I4,24),1,Control!$A$1:$A$13),IF(G4="Every 3 Years",WORKDAY(EDATE(I4,36),1,Control!$A$1:$A$13),"")))),"")))))))

Thank you for the assistance.

 

[Fluff]

You have too many closing brackets & one in the wrong place, try

=IFERROR(IF(OR(ISNUMBER(SEARCH("Expedite",D4)),ISNUMBER(SEARCH("Urgent",D4))),I4,WORKDAY(MAX(IF(ISNUMBER(I4),I4,H4),J4,K4,L4,M4),IF(G4="Annual",WORKDAY(EDATE(I4,12),1,Control!$A$1:$A$13),IF(G4="Every 2 Years",WORKDAY(EDATE(I4,24),1,Control!$A$1:$A$13),IF(G4="Every 3 Years",WORKDAY(EDATE(I4,36),1,Control!$A$1:$A$13),""))))),"")

 

[francoiscj1]

You have too many closing brackets & one in the wrong place, try

=IFERROR(IF(OR(ISNUMBER(SEARCH("Expedite",D4)),ISNUMBER(SEARCH("Urgent",D4))),I4,WORKDAY(MAX(IF(ISNUMBER(I4),I4,H4),J4,K4,L4,M4),IF(G4="Annual",WORKDAY(EDATE(I4,12),1,Control!$A$1:$A$13),IF(G4="Every 2 Years",WORKDAY(EDATE(I4,24),1,Control!$A$1:$A$13),IF(G4="Every 3 Years",WORKDAY(EDATE(I4,36),1,Control!$A$1:$A$13),""))))),"")

Thank you for catching my error and correcting it. It works!!

 

[Fluff]

You're welcome & thanks for the feedback.