Counting the number of times a date/s is inside a series of start and finish dates

[Ross_61]

Hello and thank you for allowing me into this forum.

I am trying solve a problem.

I have a table of 20 rows (at the moment) in which there are columns with 'in dates' and 'out dates'. I add a row every few days.

I then have two cell dates, A and B. B will always be after A

What formula would be recommended to determine if the two cell dates appear including and in-between the table which has the 'in dates' and 'out dates'?

I have tried 'COUNTIFS' but am struggling with the correct arguments.

Many thanks in advance.

[Phuocam]

Try this:

=COUNTIFS('out dates', ">="&A,'in dates', "<="&B)

[Ross_61]

Many thanks for the assistance.