convert date time stamp to date only

[Enjoy1953]

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

[MrShorty]

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]

Hello,
I have a similar case but unable to find the correct formula,
The date I have is in the text format, 'Dec 1 2016 12:00AM' and I need to show it as yyyy-mm-dd, so the date is to be represented as 2016-12-01.
Please let me know the best way to go about it.

[alansidman]

@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

[Enjoy1953]

Mr.Shorty,
That worked. Thank you so much. I thought it would a much more complicated formula. LOL

[Enjoy1953]

thank you so much. That worked like a charm. Didn't expect the formula to be so simple! LOL