How do I change the date format if my column type is Created Date?

rmiro

Hello,

How do I change the format if my column type is Created Date? Currently it is also showing the time, but I would like for only the date to show if possible. Thank you in advance.

SoS | Dan Palenchar

Make a new Date column in your Sheet and add formula =DATEONLY([Created Date]@row) as a column formula.

You can then freely apply the formatting of your choice.

SoS | Dan Palenchar

Make a new Date column in your Sheet and add formula =DATEONLY([Created Date]@row) as a column formula.

You can then freely apply the formatting of your choice.

rmiro

@Dan Palenchar thank you for your help! I will try that

SoS | Dan Palenchar

@rmiro happy to help!