Forum Discussion

Anonymous's avatar
Anonymous
Jul 19, 2022

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

 

Resources