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

Excel Wisdom
Using a mouse in Excel is the work equivalent of wearing a lanyard when you first get to college

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
4
Views
665
Replies
11
Views
503
Replies
1
Views
335
Replies
3
Views
269
Replies
1
Views
329

1,141,309
Messages
5,705,672
Members
421,404
Latest member
Mikecollo

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.

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