cell a1 = 1206. This is really 12/1/06 in a date format, and this is the string I need to derive from this representation.
cell a2 = 107. This is really 1/1/07 in a date format, and this is the string I need to derive from this cell.
I need to write something like this: =if(len(a1) = 4, sustring(a1, 1, 2) & "/1/" & substring(a1, 3, 2), "do something else.")
How do I translate the substrings that I want into excel?
Start Free Trial
