Search for a date within a Date range in excel

I'm looking for a ready function in excel or using IF-Statement to find a specific Date-Time within a Range in table that has large amount of rows, for example: These are sample of the Date Range i want to search in:

XYZ example

So i used the following equation to search for certain dates like:

AC look for

           Now this column has the values that i want to know
           if each row of the AC column is included/contained 
           between the range of the two columns above.

I have used this If statement before: IF(AND(AC5>=AE5,AC5<=AF5),"1","0") but it wasn't effective, because it compares each row by itself and i want to compare each cell in AC with the whole table of (XYZ) columns..

Any recommendations please?