Hello Gurus,
I have challenge converting the Text to Date format, i have DMMYYYY, DDMYYYY, DDMMYYYY date formats.
I have two text with Len=7, ex: 0422024, 4102024, the result should be 04022024 and 04102024.
I got the formula, but i want to combine two formulas by using IF condition.
in C1 the the output should be =If (Len(A1)=7, then Date formula1 (B1) or Date formula 2 (B2))
thanks
Bookmarks