I often have sheets with dates written in different formats than the one GS recognizes as a date. What's a painless way to convert those to dates, perhaps by specifying a format string?

So to clarify, this would be the inverse of TEXT(DATE(1969,7,20),"yyyy-MM")

I'm working on a custom JavaScript function, but haven't gotten the code right yet.

  • 1
    Add sample input data and the code of the custom function that tried to make. If you got an error message add it textually. – Rubén Dec 2 '18 at 15:10

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.