How do I convert this format to "Fri Oct 23 21:49:22 EST 2015" to "Oct 2015" by means of a formula?
How do I convert this format to "Fri Oct 23 21:49:22 EST 2015" to "Oct 2015" by means of a formula?
If you want that as a proper date which is formatted to show only the month and year, you can do this:
=DATEVALUE(MID(A1,9,3)&MID(A1,5,4)&RIGHT(A1,4))
or this:
=DATE(RIGHT(A1,4),MATCH(MID(A1,5,3),{"Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec"},0),MID(A1,9,2))
assuming that date/time string is in A1. Format the cell using a Custom Format of:
"mmm yyyy"
then you can copy down if you have other date/times to convert.
Hope this helps.
Pete
It worked. Thanks Pete
You're welcome, and thanks for the rep.
If that takes care of your original question, please select Thread Tools from the menu above your first post and mark this thread as SOLVED.
Pete
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks