=IF(ISBLANK(A2),A2,IF(ISNUMBER(A2),A2,DATEVALUE(LE FT(A2,10))))

"Jim" wrote:

Hello,

I need a little help changing this formula:

=IF(ISNUMBER(A2),A2,DATEVALUE(LEFT(A2,10)))

to return a blank if the referencing cell is blank. I appreciate the help.

jim