Assistance with Split Function

[mauddib13]

I am attempting to search through column "P" and mark "1" in column "Q" if it contains Current date and Name next to it. The only problem is that the entrys will be something like "5/13/2008 8:51:24 AM Raul Martinez Sent Email to Analyst for Status Update." So what I need to do is search through all the information in that cell and find the DATE and then look to see if the Name is tied to it. can anyone help?

[NBVC]

..then look to see if the Name is tied to it

how are you supposed to know this? Is there a list to match up against?

[mauddib13]

Sorry, Forgot to upload an example... Here is an example file. I know it is very vague but basically I need to search through a exported worklog to find any criteria where Adam updated the worklog for that specific date.

[NBVC]

Perhaps in Q1:


=--ISNUMBER(MATCH("5/13/2008"&"*Adam Beutnagel*",P1,0))

or if you have the date stored in say A1 and the name in B1, then....

=--ISNUMBER(MATCH(TEXT($A$1,"m/dd/yyyy")&"*"&$B$1&"*",P1,0))

either formula copied down will give 1 if a match found and 0 if not.