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

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???



1 Reply


Try this: