Translation of Multiple Date Types

[meppwc]

I am looking for a formula that can accomplish the following

In column A (text field) I have dates that were pasted from 2 different applications
The dates can be in two different formats (1/6/2015 or 06/Jan/15 04:01 AM CST)
In column B I need a formula that provides me a date with the 1/6/2015 format.

I have the formula (below) that will translate the 06/Jan/15 04:01 AM CST to the format that I need
=IF(A1="","",IF(ISNUMBER(SEARCH("C",A1)),DATEVALUE(LEFT(A1,13)),A1))

But now I need to add logic to this formula that basically says:
If the format in A is 1/6/2015 then the value in B is 1/6/2015
If the format in A is 06/Jan/15 04:01 AM CST then the value in B is still 1/6/2015

[Tony Valko]

This worked for both examples...

=DATEVALUE(LEFT(A1,9))

Format as Date

Data Range

	A	B
1	06/Jan/15 04:01 AM CST	1/6/2015
2	1/6/2015	1/6/2015