My WORKDAY IF formula is getting error too many arguments can anyone advise?

[Lisa720]

Hi there

I have created a call log spreadsheet which uses a WORKDAY If formula to calculate the deadline depending on the drop down options of Today, 48 hours and 72 hours excluding weekends. This formula is as follows

=WORKDAY(A2,IF(I2="Today",0,IF(I2="48 hours",2,IF(I2="72 hours",3))))

I now need to also exclude Bank Holidays so I listed bank Holidays and added the cell range of dates to my formula but it now returns the error too many arguments. Can anyone help me fix this?

My formula that doesn't work is

=WORKDAY(A2,IF(I2="Today",0,Q2:Q20, IF(I2="48 hours",2,Q2:Q20, IF(I2="72 hours",3,Q2:Q20))))

Many thanks

 

[GraH]

The range with holidays should be in one of the arguments of WORKDAY, in your formula it is a fourth argument of the last IF.
Use intellisence guide to correct it. Insert the range of holidays just before the last closing parenthesis.

 

[Lisa720]

Thank you for responding do you mean this?

=WORKDAY(A2,IF(I2="Today",0,IF(I2="48 hours",2,IF(I2="72 hours",3,(Q2:Q20)))))

 

[GraH]

No, more like this.
=WORKDAY(A2,IF(I2="Today",0,IF(I2="48 hours",2,IF(I2="72 hours",3))),Q2:Q20)
I'm without Excel for the moment, so please check via the built-in intellisence all the arguments of the WORKDAY function.

 

[Lisa720]

That is perfect thank you so much for your help with this

 

[GraH]

Probably you need to put some "$" in the holiday range as well: $Q$2:$Q$20. I'm assuming you are dragging down the formula.