Count IFS between 2 dates with multiple ranges

[RebelAlley]

I'm having an issue with my formula. What I want to do is count the number of times a date is in between 2 dates. I have a list of people and days they took off, each day is in a separate cell and each person is one row. I'm trying to string together multiple rows for my range. On another tab I have a column for the date at the beginning of the week (A) and the end of the week (B). This is what it looks like right now:
=SUM(COUNTIFS(INDIRECT({"Holiday!B16:BP16","Holiday!B29:BP29","Holiday!B41:BP41"}),"<="A2),(INDIRECT({"Holiday!B16:BP16","Holiday!B29:BP29","Holiday!B41:BP41"}),">="B2))

Excel won't even accept this as a formula and my head is starting to hurt thinking about it.

I also tried this which isn't working - it is picking up dates that are after the end of the week =SUM(COUNTIF(INDIRECT({"Holiday!B17:BP17","Holiday!B30:BP30","Holiday!B42:BP42"}),">="&[@End]-"6"))

 

[LMacD]

I am not to clear how your spreasdsheet is set up. Here is my guess.

The dates are a named range call DaysOff

Person1	1/5/2019	1/13/2019	2/7/2019
Person2	1/13/2019	1/21/2019
Person3	1/21/2019	2/23/2019
Person4	2/23/2019	3/17/2019

<colgroup><col><col><col span="2"><col span="2"></colgroup><tbody>
</tbody>

(Not the full range)
On another sheet

Beginning of week	End of Week		Count Days Off
1/1/2019	1/5/2019		1
1/6/2019	1/13/2019		2
1/14/2019	1/21/2019		2
1/22/2019	1/29/2019		0

<tbody>
</tbody>

In the cells in column "Count Days Off" I put this formula in each cell

[FONT=Verdana]=COUNTIFS(DaysOff,">=" & A2,DaysOff,"<=" & B2)
[/FONT]