Formula that checks if an ID falls between two dates and a single date

[Leicester City Fox]

Hi All


Want a formula thatcheck if an ID falls between two dates and a single date.
The will help me state they were staying at are home betweenthe dates below or they went to the hostel or they went aboard between thesedates.
I have an ID numbers and two dates see example below of whenpeople were at are home:
Home ID Dates crosscheck
A B C
2) ID No. StartDate End Date
3) 2321 12/01/2018 22/02/2019
4) 5437 01/06/2017 13/04/2019
50 2345 08/05/2019 11/11/2019

Hostel Tab
I want a formula that cross checks these data and ID No.above. With another tab which gives customerID Nos and dates, showing the start date they went in the end date the left hostileand when they left the hostel and if these dates fall within the dates above.
Aboard Tab
I have another tab that states the IDs and show one date theywent aboard. Again, I want to know if this falls within the dates above.

I am grateful for any help in the matter or ideas.
Many Thanks
Leicester Fox

 

[mikerickson]

Re: Want a formula that checks if an ID falls between two dates and a single date

The formula
=COUNTIFS(A:A, F2, B:B, "<="&F3, C:C, ">="&F3)

Will tell if the ID number in F2 was at home on the date in F3

 

[Leicester City Fox]

Re: Want a formula that checks if an ID falls between two dates and a single date

Hi Mikerson

Good Morning

Thanks for the example it don't appear to work on the dates on the other tabs.

Thanks Anyway

The Leicester Fox