I have the following string in cell A1 as follows "Tuesday, March 01, 2016 5:09 AM". I have tried to format as date but does not work. Is there formula to convert this to a date? Desired result is 3/1/2016.
I have the following string in cell A1 as follows "Tuesday, March 01, 2016 5:09 AM". I have tried to format as date but does not work. Is there formula to convert this to a date? Desired result is 3/1/2016.
Hi maacmaac,
Get rid of the Tuesday and then use =DateValue() on the rest of the string.
See the attached for the example.
DateValue after removing Day Name.xlsx
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
If you cannot get rid of teh day name, and teh format is always like that (name comma date), try this...
=DATEVALUE(MID(A1,FIND(",",A1)+2,99))
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Happy to help and thanks for the rep
Or try this... =--RIGHT(A1,LEN(A1)-FIND(",",A1)-1)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks