Forum Discussion
Extract date from a string
Hello there I have a message i copy every day and it has dates in them as following format Wed Jun 3rd, 2020 How can i come up with an equation to change this into a date? Regards
I managed to make it work with LEFT and RIGHT equations then DATEVALUE then DATE to combine all of them
Let me know if theres any easier way? because this depends on the format never changing
Can you give any further context on what you're using this for or doing with the message?
Are you copying from one location a date that's given to you in that format and then pasting into a spreadsheet, if so what do you do with it next/for what reference?
Or are you trying to have a field in excel state the current date information in that context for something else to reference?
Are you copying from one location a date that's given to you in that format and then pasting into a spreadsheet, if so what do you do with it next/for what reference?
Or are you trying to have a field in excel state the current date information in that context for something else to reference?