convert date time stamp to date only

I am trying to find a formula to change these donation dates with timestamp to just a date. I have tried removing the T and Z contained in each entry and then convert the numbers but still no luck.
thanks

The values in column A are simple text strings. If we can assume that the format is always the same, I would:
1) use the LEFT() function to extract the date string LEFT(A2,10)
2) Then use the DATEVALUE() function to conver the date as string to a date serial number =DATEVALUE(LEFT(A2,10))

@privac
Administrative Note:

Welcome to the forum.

We are happy to help, however whilst you feel your request is similar to this thread, experience has shown that things soon get confusing when answers refer to particular cells/ranges/sheets which are unique to your post and not relevant to the original.

Please see Forum Rule #4 about hijacking and start a new thread for your query.

If you are not familiar with how to start a new thread see the FAQ: How to start a new thread