Join ranges to set holidays.

[eduzs]

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:

=Workday(now(),1,NationalHolidays+RegionalHolidays)

Thanks.

 

[Saurabhj]

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

 

[Dave Patton]

I think that you will have prepare a single list that includes the dates from the 2 lists.

 

[Fluff]

How about

=WORKDAY(TODAY(),1,CHOOSE({1,2},B1:B10,J1:J10))

Note that the two ranges need to be the same size

 

[eduzs]

Thanks all.

 

[Fluff]

Glad you sorted it & thanks for the feedback.

 

[Saurabhj]

Thanks for the feedback, eduzs.