date with hours

[Marlene_Nadeau]

Hello when i request an excel file of my work on Trello the date field always appears with the hours.  I would like only  the date to appear.  Do you know how to do it?  Thank you

[Ryan]

Hi Marlene,

When you export this information from Trello the timestamp will always be there. However, you should be able to get the time out of this, by adding a new row in your excel sheet which only has the date. To extract the date, just use "=INT(A1)" in the new row with A1 being the cell which you want to convert.

You might need to make sure these cells are formatted to show dates correctly too. Here is an article which could help you to do this: https://www.exceltip.com/tips/remove-time-on-date-time-stamp.html

Thanks!

Ryan