Lookup Start Date And End Date Range For Specific Date Using Formula

[mahmoud-lee]

Hi!
In column (A) some dates
I want when you enter a date to be brought start date and the end date for this period
I hope to have a solution by the formula

[Excel Fox]

D27=INDEX($A$1:$A$60,MATCH(C27,$A$1:$A$60))
E27=SMALL(INDEX($A$1:$A$60,MATCH(C27,$A$1:$A$60)): $A69,2)

[mahmoud-lee]

I am very sorry
No start date is also working
But the end date works great
Well I found the right solution

[mahmoud-lee]

But I need you anything else
I need
Is this the time (15:03:34) is located between the time (10:00:00) to the time 17:00:00 ?

[Excel Fox]

The formula I posted works perfectly for both the start date and the end date. This can be replicated for finding start time and end time range also.

[mahmoud-lee]

I want to know
Is this the time (15:00:00) is located between the (10:00:00) (17:00:00)
If you are located, including writing (1) and if you do not exist is written (0)