Jul 18 2022 07:06 PM
Jul 18 2022 07:06 PM
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???
Jul 18 2022 07:24 PM
@Deleted
Try this:
=IFERROR(--TEXT(C2,"0000-00-00"),C2)