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.
Bookmarks