I was not able to determine if the cell was a date, but I was able to
see if it was text so...

=IF(ISTEXT(<cell),IF(LEN(<cell)6,RIGHT(<cell,4 ),"
")&"/"&MID(<cell,4,2)&"/"&LEFT(<cell,2),TEXT(<cell,"yyyy/mm/dd"))

works for fixed length invald dates. Now to get the non fixed
lengths...

Thanks for any input.