Converting Text Date Values

Hi All

i have an export of data where the date format comes out in [25 JAN 21] format, please can someone help with a formula/way to convert into normal date format?

please see attached actual format vs desired output

many thanks

David

The issue is that the date field is a text value, so for date formatting to work it needs to be converted into a numeric value.

Try this formula in cell B3:

Formula:

Please Login or Register  to view this content.