Convert date of text type to formatted date

To convert field values with date value but with text type in a spreadsheet.

Choose data > Text to columns..

Choose the delimiter for example “/” and it will generate 3 columns.

Can reformat the date with =A3&-A2&-A1 (YYYY-MM-DD)


Leave a Reply

Your email address will not be published. Required fields are marked *