# Join ranges to set holidays.

#### eduzs

##### Well-known Member
Excel Formula:
``WORKDAY(start_date, days, [holidays])``
I need to use two holidays ranges in this excel worksheet function.
Is there a way to create a named range that join two or even more ranges of holidays?
Like AllHolidays=B1:B10 + J5:J10
Example:
Excel Formula:
``=Workday(now(),1,NationalHolidays+RegionalHolidays)``
Thanks.

### Excel Facts

Excel motto
Not everything I do at work revolves around Excel. Only the fun parts.

#### Saurabhj

##### Active Member
Simple way can be:
=WORKDAY(now(),1,B2:J10)

#### Dave Patton

##### Well-known Member
I think that you will have prepare a single list that includes the dates from the 2 lists.

#### Fluff

##### MrExcel MVP, Moderator
Excel Formula:
``=WORKDAY(TODAY(),1,CHOOSE({1,2},B1:B10,J1:J10))``
Note that the two ranges need to be the same size

Thanks all.

Last edited:

#### Fluff

##### MrExcel MVP, Moderator
Glad you sorted it & thanks for the feedback.

#### Saurabhj

##### Active Member
Thanks for the feedback, eduzs.

Replies
7
Views
130
Replies
1
Views
218
Replies
2
Views
102
Replies
7
Views
313
Replies
0
Views
196

1,141,315
Messages
5,705,693
Members
421,406
Latest member
kluna90

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