# 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

Round to nearest half hour?
Use =MROUND(A2,"0:30") to round to nearest half hour. Use =CEILING(A2,"0:30") to round to next half hour.

#### 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
1
Views
280
Replies
11
Views
389
Replies
1
Views
287
Replies
3
Views
224
Replies
1
Views
286

1,136,290
Messages
5,674,893
Members
419,532
Latest member
longphamtel

### 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.

### Which adblocker are you using?

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

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