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

#### Lisa720

##### New Member
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

### Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},\$Z\$1:\$Z\$99,\$Y\$1:\$Y\$99),2,False) to lookup Y values to left of Z values.

#### GraH

##### Well-known Member
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

##### New Member
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

##### Well-known Member
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

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

#### GraH

##### Well-known Member
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.

Replies
11
Views
257
Replies
1
Views
202
Replies
3
Views
182
Replies
1
Views
239
Replies
2
Views
579

Threads
1,130,237
Messages
5,641,026
Members
417,188
Latest member
DrTees

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

### Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

### Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back