Forum Discussion
Help with Text to Date Formula
Hello, I have been using many different methods for attempting to convert text and date - but failing miserably! Essentially, the way I can download data provides dates that appear like this: ...
I suppose it is a string.
If so, you may consider LEFT and MID function to extract the information about year/month/day. Then, use the function DATE, you can have the date in your formatting.
Hope that it is helpful.