Compare dates from strings and then find first date greater than a date

Hi

I have data like following cells in column A.

23 Jan 18 13:15:31 CLEAR - Item: 0000000106837 Qty: 1 591ML VIT WT
23 Jan 18 13:15:31 CLEAR - Item: 0000000051270 Qty: 1 ENVIRONMENTA
23 Jan 18 13:19:00 Underpumped prepay - prepaid $43.29,pumped $35.00
23 Jan 18 13:20:24 TAG 9B (TSI) CR=5: b1=68, b2=0
23 Jan 18 13:24:09 TAG 9B (TSI) CR=6: b1=e8, b2=0
23 Jan 18 13:24:50 Minimum age of 19 verified
23 Jan 18 13:27:02 TAG 9B (TSI) CR=3: b1=e8, b2=0
23 Jan 18 13:27:47 TAG 9B (TSI) CR=8: b1=e8, b2=0

I want to search first cell after 23 Jan 18 13:20:00 using vba. Result should be the one highlighted.

Thanks for help

try this:

Please Login or Register  to view this content.

Try

Please Login or Register  to view this content.