Display VALUE if Condition Match

[Zohaib Hassan]

Dear Team,
Kindly help in my query, following is the explanation.
[TABLE="width: 250, align: left"]
<tbody>[TR]
[TD="align: center"]A[/TD]
[TD="align: center"]B[/TD]
[/TR]
[TR]
[TD="align: center"]1/3/2018 12:15 pm[/TD]
[TD="align: center"]2/3/2018 03:20 am[/TD]
[/TR]
[TR]
[TD="align: center"]5/3/2018 2:15am[/TD]
[TD="align: center"]7/3/2018 9:00 am[/TD]
[/TR]
</tbody>[/TABLE]

​

[TABLE="width: 250, align: left"]
<tbody>[TR]
[TD="align: center"]C[/TD]
[TD="align: center"]D[/TD]
[TD="align: center"]E[/TD]
[TD="align: center"]F[/TD]
[TD="align: center"]G[/TD]
[TD="align: center"]H[/TD]
[TD="align: center"]I[/TD]
[/TR]
[TR]
[TD="align: center"]1/3/2018[/TD]
[TD="align: center"]2/3/2018[/TD]
[TD="align: center"]3/3/2018[/TD]
[TD="align: center"]4/3/2018[/TD]
[TD="align: center"]5/3/2018[/TD]
[TD="align: center"]6/3/2018[/TD]
[TD="align: center"]7/3/2018[/TD]
[/TR]
[TR]
[TD="align: center"]OK[/TD]
[TD="align: center"]OK[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]OK[/TD]
[TD="align: center"]OK[/TD]
[TD="align: center"]OK[/TD]
[/TR]
</tbody>[/TABLE]

​

I WANT, IF A1 HAVE THE STARTING DATE AND B1 HAVE THE ENDING DATE THAN C2 TO D2 WILL DISPLY "OK" SAME AS A3 HAVE STARTING AND B3 HAVE ENDING DATE THAN G2 TO I2 WILL DISPLY "OK" .

SO IF WE CHANGE THE STARTING AND ENDING DATE AUTOMATICALLY IT WILL DISPLY THE RESULT COMPARING WITH THE ASSIGN DATE IN C,D,E,F,...........

VBA NOT ALLOWED.....

 

[Special-K99]

CAPS OFF please!

This may need changing as your input is not uniform

in C2
=IF(AND(C1>=INT(A1),C1<=INT(B1)),"OK","")
copy to D2

in G2
=IF(AND(G1>=INT(A3),G1<=INT(B3)),"OK","")
copy across to I2

 

[Zohaib Hassan]

[TABLE="width: 1370"]
<tbody>[TR]
[TD][/TD]
[TD]A
[/TD]
[TD]B
[/TD]
[TD][/TD]
[TD]D
[/TD]
[TD]E
[/TD]
[TD]F
[/TD]
[TD]G
[/TD]
[TD]H
[/TD]
[TD]I
[/TD]
[TD]J
[/TD]
[TD]K
[/TD]
[TD]L
[/TD]
[TD]M
[/TD]
[TD]N
[/TD]
[TD]O
[/TD]
[TD]P
[/TD]
[TD]-
[/TD]
[TD]-
[/TD]
[TD]-
[/TD]
[TD]-
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]1-9-2018 12:00 AM
[/TD]
[TD]2-9-2018 9:04 AM
[/TD]
[TD][/TD]
[TD]DATE
[/TD]
[TD]1-9-2018
[/TD]
[TD]2-9-2018
[/TD]
[TD]3-9-2018
[/TD]
[TD]4-9-2018
[/TD]
[TD]5-9-2018
[/TD]
[TD]6-9-2018
[/TD]
[TD]7-9-2018
[/TD]
[TD]8-9-2018
[/TD]
[TD]9-9-2018
[/TD]
[TD]10-9-2018
[/TD]
[TD]11-9-2018
[/TD]
[TD]12-9-2018
[/TD]
[TD]-
[/TD]
[TD]-
[/TD]
[TD]-
[/TD]
[TD]-
[/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD]5-9-2018 12:18 AM
[/TD]
[TD]6-9-2018 9:23 AM
[/TD]
[TD][/TD]
[TD]DURATION
[/TD]
[TD]1
[/TD]
[TD]1
[/TD]
[TD][/TD]
[TD][/TD]
[TD]1
[/TD]
[TD]1
[/TD]
[TD][/TD]
[TD][/TD]
[TD]1
[/TD]
[TD]1
[/TD]
[TD]1
[/TD]
[TD][/TD]
[TD]-
[/TD]
[TD]-
[/TD]
[TD]-
[/TD]
[TD]-
[/TD]
[/TR]
[TR]
[TD]3
[/TD]
[TD]9-9-2018 12:37 AM
[/TD]
[TD]11-9-2018 9:42 AM
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4
[/TD]
[TD]13-9-2018 12:56 AM
[/TD]
[TD]14-9-2018 10:01 AM
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5
[/TD]
[TD]17-9-2018 1:15 AM
[/TD]
[TD]18-9-2018 10:20 AM
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]6
[/TD]
[TD]21-9-2018 1:34 AM
[/TD]
[TD]22-9-2018 10:39 AM
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]7
[/TD]
[TD]25-9-2018 1:53 AM
[/TD]
[TD]26-9-2018 10:57 AM
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]8
[/TD]
[TD]29-9-2018 2:12 AM
[/TD]
[TD]30-9-2018 11:16 AM
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="colspan: 21"]Dear what I require is , suppose if I put starting value in A1 and ending value in B1 than E2 to F2 display any value(I display 1) same as if I put starting value in A2 and ending value in B2 than I2 to J2 display any value. Also check In the table M2 N2 O2 DISPLAY 1 B/C A3 and B3 have the exact date comparision with M1-O1. NOTE: The date in column A and B varies not fix, it will display the value with comparison of starting and ending date.
[/TD]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
</tbody>[/TABLE]