Resolving Dates in Texts to remove #Value errors

[CoachJava]

I need to do some quality checks for manual entries by staff into a system which generates an export. I receive the export with entered dates in text form. I need to simply determine if the dates were entered correctly (i.e. proper format). I need formulas for future projects.

Column A in table below is the text from the export. Column B simply is =if(A2*1>0,"YES","NO"). I need to figure a way to resolve the #value! errors so if the date is incorrect and cannot display a value, it says "NO".

Any suggestions would be GREATLY appreciated.

7/15/2015	YES
77/12/2015	#VALUE!
7/14/2015	YES
7/11/2015AA	#VALUE!
7/17/2015	YES

<tbody>
</tbody>

 

[Jonmo1]

Try ISNUMBER insted

=IF(ISNUMBER(A2*1),"YES","No")

Or if TRUE/FALSE results is sufficient instead of Yes/No, then simply
=ISNUMBER(A2*1)

 

[mole999]

can you just not filter on that column where its not equal to YES