Convert text to date in LibreOffice Calc

When I import a .csv that contains a date field into LibreOffice Calc, and I set that column to DATE the content is prefixed with a single quote ('). That's annoying because I can't use functions on it: the single quote makes Calc use the content as free text.

To remove the single quote, select the column with dates and do a search and replace (CTRL + H): search for ^.*$ and replace it with &.

This solution was given by tohuwawohu on StackOverflow.