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.

[TABLE="class: grid, width: 50"]
<tbody>[TR]
[TD]7/15/2015[/TD]
[TD]YES[/TD]
[/TR]
[TR]
[TD]77/12/2015[/TD]
[TD]#VALUE![/TD]
[/TR]
[TR]
[TD]7/14/2015[/TD]
[TD]YES[/TD]
[/TR]
[TR]
[TD]7/11/2015AA[/TD]
[TD]#VALUE![/TD]
[/TR]
[TR]
[TD]7/17/2015[/TD]
[TD]YES[/TD]
[/TR]
</tbody>[/TABLE]

 

[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