Trying To get IF formula to work with date formula along with Left, Mid, and Right

Deleted
Not applicable

I am trying to use the date function with left, mid & right, but if I have a zero in the date cell I need that zero to still come over. I have been trying to incorporate the IF/Then function but not having any success. please see my screen shot. What am I doing wrong???

M_Nita2_0-1658196384828.png

 

1 Reply

@Deleted 

Try this:

=IFERROR(--TEXT(C2,"0000-00-00"),C2)