Formula to convert this date format (YYYY.MM.DD.) to (DD/MM/YYYY)

1

Hello! Is there a way to give a formula to a column which automatically formats this date format: 2022.03.05. to 05/03/2022 when I copy and paste this 2022.03.05. and so in this way get the column type as date correctly?

2

can be written directly in the EU format, but I would advice to first format into the ‘coda format’ which is MM/DD/YYYY and via the column settings display it into the EU format.

Below one option, there are many:

image
image1994×731 81 KB

enjoy!

2 Likes
3

Wooow! You are a super hero! Thanks a lot!

4

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.