Find 12 Hr Format date from 24 Hr Text String

[caabdul]

I have set MyDate as Date

MyDate = 12/17/17 07:52:52 PM

I want to search this in following data in column A. Search result is present at cell A5.

17 Dec 17 19:51:33 Extra Load
17 Dec 17 19:52:09 Minimum age of 18 verified
17 Dec 17 19:52:16 Extra Load
17 Dec 17 19:52:47 Extra Load
17 Dec 17 19:52:52 Minimum age of 18 verified
17 Dec 17 19:55:32 Villaged
17 Dec 17 20:00:10 Minimum age of 18 verified
17 Dec 17 20:00:24 Old Relative
17 Dec 17 20:02:32 Villaged

Can a vba code search this 12 HR format date from 24 Hr format text data and return the row number of that cell from range.

[YasserKhalil]

Try this code

Please Login or Register  to view this content.

[jindon]

Try

Please Login or Register  to view this content.

[YasserKhalil]

That's great Mr. Jindon
I have used a UDF to get the months abbreviations Jan, Feb and so on because the regional settings for me is different ..Is there another way to have the English months names without a UDF ..? I mean to implement the regional settings point in your code

[caabdul]

Thanks guys, Format Function did the trick.

[YasserKhalil]

You're welcome. Glad it worked for you
Thanks for the rep. points