Identifying Rows with Date Strings Using '/'

[copyboy007]

I have a column of mixed raw data that includes dates where the numbers are either 1-digit or 2-digit for the month, day and year.

aaa
zzz
333
1/10/16 123g4
xyz
10abc
7/3/20 xwyz56
123 $4567
10/15/18 12345

Is there a formula for the next column to indicate, for example, 'xxx', wherever there's a row with a date? One constant is the date rows have the two slashes ('/'), if that helps.

 

[snjpverma]

Try this:
Oops. I made the changes to the formula..
Check this revised one.

Book1
	A	B
2	aaa	No Date
3	zz1/2	No Date
4	333	No Date
5	1/10/16 123g4	Date
6	xyz	No Date
7	10abc	No Date
8	7/3/20 xwyz56	Date
9	123 $4567	No Date
10	10/15/18 12345	Date
Sheet1

Cell Formulas
Range	Formula
B2:B10	B2	=IF(LEN(A2)-LEN(SUBSTITUTE(A2,"/",""))>1,"Date","No Date")

 

[Rick Rothstein]

This should work...

=IF(COUNTIF(A1,"*/*/*"),"xxx","")

 

[snjpverma]

This should work...

=IF(COUNTIF(A1,"*/*/*"),"xxx","")

Elegant piece as usual from you.

 

[copyboy007]

Both formulas work nicely. Thank you, both.