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
Last edited by mahmoud-lee; 06-14-2013 at 05:45 AM.
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)
A dream is not something you see when you are asleep, but something you strive for when you are awake.
It's usually a bad idea to say that something can't be done.
The difference between dream and aim, is that one requires soundless sleep to see and the other requires sleepless efforts to achieve
Join us at Facebook
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.
A dream is not something you see when you are asleep, but something you strive for when you are awake.
It's usually a bad idea to say that something can't be done.
The difference between dream and aim, is that one requires soundless sleep to see and the other requires sleepless efforts to achieve
Join us at Facebook
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)
Posting Permissions
Reply With Quote
Bookmarks