If a date is cut off like in for instance 1/31/
how do you want the result of that?

--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon




wrote in message
oups.com...
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.