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
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
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)
I am very sorry
No start date is also working
But the end date works great
Well I found the right solution
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 ?
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.
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)