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

Lisa720

New Member
Joined
May 16, 2020
Messages
3
Office Version
  1. 2010
Platform
  1. Windows
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

What is =ROMAN(40) in Excel?
The Roman numeral for 40 is XL. Bill "MrExcel" Jelen's 40th book was called MrExcel XL.

GraH

Well-known Member
Joined
Mar 22, 2020
Messages
754
Office Version
  1. 365
  2. 2016
Platform
  1. Windows
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
Joined
May 16, 2020
Messages
3
Office Version
  1. 2010
Platform
  1. Windows
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
Joined
Mar 22, 2020
Messages
754
Office Version
  1. 365
  2. 2016
Platform
  1. Windows
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
Joined
May 16, 2020
Messages
3
Office Version
  1. 2010
Platform
  1. Windows
That is perfect thank you so much for your help with this
 

GraH

Well-known Member
Joined
Mar 22, 2020
Messages
754
Office Version
  1. 365
  2. 2016
Platform
  1. Windows
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,132,803
Messages
5,655,391
Members
418,195
Latest member
LabraLime

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

Which adblocker are you using?

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
Top