ISO date conversion in Libre Office Calc

Posted on by

Simple solution to to transform an ISO date string like 2019-04-16 into a Date in Libre Office Calc.

With the date string in cell A1, I use this formula in the target string:

=DATE(LEFT(A1,4),MID(A1,6,2),RIGHT(A1,2))

Similar transformations can be performed when the date string is formatted in different variations.