#NAME? Error on a multicondition formula

[raysha22]

I have the following formula and it is giving me the #NAME? error. Can anyone identify what is wrong with my formula or help me write a better one?

=IF(C37=””,””,(IF(AND(C38>1,C3="Standard",(WEEKDAY(C38+2)=1)),(WORKDAY((C38+2),2,Holidays!B2:F40)),IF(AND(C38>1,C3="Standard",(WEEKDAY(C38+2)=2)),(WORKDAY((C38+2),1,Holidays!B2:F40)),IF(AND(C38>1,C3="Standard",(WEEKDAY(C38+2)=3)),(WORKDAY((C38+2),2,Holidays!B2:F40)),IF(AND(C38>1,C3="Standard",(WEEKDAY(C38+2)=4)),(WORKDAY((C38+2),1,Holidays!B2:F40)),IF(AND(C38>1,C3="Standard",(WEEKDAY(C38+2)=5)),(WORKDAY((C38+2),5,Holidays!B2:F40)),IF(AND(C38>1,C3="Standard",(WEEKDAY(C38+2)=6)),(WORKDAY((C38+2),4,Holidays!B2:F40)),IF(AND(C38=””,C3="Standard",(WEEKDAY(C37+2)=1)),(WORKDAY((C37+2),2,Holidays!B2:F40)),IF(AND(C38=””,C3="Standard",(WEEKDAY(C37+2)=2)),(WORKDAY((C37+2),1,Holidays!B2:F40)),IF(AND(C38=””,C3="Standard",(WEEKDAY(C37+2)=3)),(WORKDAY((C37+2),2,Holidays!B2:F40)),IF(AND(C38=””,C3="Standard",(WEEKDAY(C37+2)=4)),(WORKDAY((C37+2),1,Holidays!B2:F40)),IF(AND(C38=””,C3="Standard",(WEEKDAY(C37+2)=5)),(WORKDAY((C37+2),5,Holidays!B2:F40)),IF(AND(C38=””,C3="Standard",(WEEKDAY(C37+2)=6)),(WORKDAY((C37+2),4,Holidays!B2:F40))))))))))))))))

Thanks in advance!

 

[jimrward]

What is your formula trying to achieve

 

[raysha22]

What is your formula trying to achieve

I have multiple conditions I need in order to determine what date to put in a cell.
1. C3 needs to ="Standard"
2. It needs to identify what day of the week it is to determine how many days to add to get the final day (my final date has to be the next Tues or Thurs that falls at least two days after the original date C38)
3. The date cannot fall on certain determined Holidays on another chart.

Example:
C3 = Standard
C38 = 2/28/18
C40 (Cell I'm populating with formula) = 3/6/18 (2/28/18 +2 days and then the following Tuesday or Thursday)

Does that help?

 

[Joe4]

You need to have the Analysis ToolPak Add-In installed to use the WORKDAY function, otherwise you will get the #NAME error.
Do you have that installed?

 

[raysha22]

You need to have the Analysis ToolPak Add-In installed to use the WORKDAY function, otherwise you will get the #NAME error.
Do you have that installed?

It works everywhere else in my spreadsheet. With this one formula it doesn't though.

 

[jimrward]

I feel sure I did something like this few years ago for delivery dates with a shorter formula but can I find the workbook when I need it, sure it can be done without that many IF’s

 

[Joe4]

Are you double-quotes really slanted like shown in your formula like this ””
I don't think Excel like that. It wants them to be straight up and down like this ""
Try replacing all instances of your slanted ones with straight ones and see if that solves the issue.
When I tried it on your formula, that error went away for me.

 

[raysha22]

Are you double-quotes really slanted like shown in your formula like this ””
I don't think Excel like that. It wants them to be straight up and down like this ""
Try replacing all instances of your slanted ones with straight ones and see if that solves the issue.
When I tried it on your formula, that error went away for me.

You are brilliant! That fixed it. I can't believe it was that simple. I typed the formula in word at first because it's easier for me to see, so it gave me the normal quote marks.
Thank you!!

 

[Joe4]

You are welcome!

Yes, it is one of those irritating things that one would never think of that has tripped most of us up somewhere along the way...