Searching for holidays within a range in between dates listed in 2 cells

[BDeCaso]

Hello, This is my first post.
Thanks for your time to read this.
I have an entry and an exit date for a reservation in 2 cells and in another worksheet I have a range of holidays listed in a column. I want to find the holidays within the dates in between the 2 cells and also know if they are weekends or weekdays.
For example, the entry date is July 3rd and the exit date is July 7. In the worksheet we have a list of all the holidays of 2017 in column A. Then I want to find out within the same formula what day of the week it is (1-7).

 

[MrTeeny]

Think you need to be clearer as to what you're looking for as your questions a bit vague so probably why no answer.

Give examples of the lookups dates format in they're in the same column as they'd have to be split to search the start and end date of the holidays, also when you ask if they are weekdays or weekends are these just one day holidays or can they have weekdays ad weekends

 

[BDeCaso]

Think you need to be clearer as to what you're looking for as your questions a bit vague so probably why no answer.

Give examples of the lookups dates format in they're in the same column as they'd have to be split to search the start and end date of the holidays, also when you ask if they are weekdays or weekends are these just one day holidays or can they have weekdays ad weekends

Thanks for your fast response MrTeeny
1) The dates are in 07/03/2017 format and the start and exit date are in separate column.
2) Some of the holidays are multiple days
[TABLE="width: 500"]
<tbody>[TR]
[TD]Entry[/TD]
[TD]Exit[/TD]
[TD]# of Holidays[/TD]
[/TR]
[TR]
[TD]07/03/2017[/TD]
[TD]07/08/2017[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

[TABLE="width: 500"]
<tbody>[TR]
[TD]Holidays[/TD]
[/TR]
[TR]
[TD]07/04/2017[/TD]
[/TR]
[TR]
[TD]07/05/2017[/TD]
[/TR]
[TR]
[TD]09/01/2017[/TD]
[/TR]
[TR]
[TD]09/02/2017[/TD]
[/TR]
</tbody>[/TABLE]


Here is a very simple version of what I am trying to do. Do I need to add anymore info to help make it clearer?
Thanks Mrteeny appreciate your feedback

 

[MrTeeny]

You can use a simple Countifs to get the # of holidays


Just enter =COUNTIFS(A6:A9,">="&A2,A6:A9,"<="&B2) in the cell, that assumes you holidays are entered in the range A6 to A9 your entry date in A2 and exit date in B2.

I'd assumed your holidays were more than a day so some might have overlapped the exit date.