Date Format - Formula

[ChrisFoster]

Hi all,

I have a spreadsheet that has the date in the following type format '2021-01-20 16:14:36 UTC'.
I need a formula please that will put it into UK format of dd/mm/yyyy. Please can someone help?

Regards,

Chris

 

[bebo021999]

If date string in A1 and its text string then in another cell try:

=DATEVALUE(LEFT(A1,10))

format this cell as any type of date that you want.

 

[ChrisFoster]

If date string in A1 and its text string then in another cell try:

=DATEVALUE(LEFT(A1,10))

format this cell as any type of date that you want.

Legend. Thanks.