I want to convert dates in attached file in to normal date fromat scuh as "Jul 03, 2019 (Jun) = 03/07/2019". Can anyone help me with how can I do that. Any help is greately appreciated
I want to convert dates in attached file in to normal date fromat scuh as "Jul 03, 2019 (Jun) = 03/07/2019". Can anyone help me with how can I do that. Any help is greately appreciated
Try this:
=DATE(MID(A1,FIND(",",A1)+2,4),MONTH(DATEVALUE(LEFT(A1,3)&" 1")),MID(A1,5,2))
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Try using text to columns, set the first option to fixed width and use a single column marker after the last digit of the year.
In the last screen of the options, set the date dropdown to MDY for the first column. Set the second column to 'Do not import / Skip'.
Apply desired formatting to column A.
Thanks lot. It works
I just noticed that you asked exactly the same question a year ago, https://www.excelforum.com/excel-gen...te-system.html
As it has been solved there, why ask again? I could be wrong, but I don't think that there is an expiry date on the duplicate thread rule
Looks like this is something you only have to deal with once annually. Please make a note of the solution offered somewhere suitable. Maybe a word document with a READ THIS title in the folder where these annually adjusted workbooks are located.
Finally, please mark this and the earlier thread as solved. Jason is right about the rule - by rights, this thread should have been closed, however as it is now solved, that action would be moot.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this and your older thread as SOLVED. Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks