Forum Discussion
Anonymous
Jul 19, 2022Trying To get IF formula to work with date formula along with Left, Mid, and Right
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???
1 Reply
Sort By
- Detlef_LewinSilver Contributor
Deleted
Try this:
=IFERROR(--TEXT(C2,"0000-00-00"),C2)