I am new to Google sheets and don't know how to write excel/google sheet formula to apply automatic formatting to a date+time value added through an external script.
I have a CRM integrated with google sheets, and it dynamically adds current date+time to a google sheet column.
The date format it adds is
2018-04-09T17:49:59 but I want this format to be changed to
2018-04-09 and time(T17:49:59) removed. So the final product is only date
Here is the image that shows what I meant.
Column C represents what is being added by the CRM and Column D is what I want it to be.
Can anyone please help me to write the proper formula that will format the date and remove the time?