|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Extracting date, month & year from a text string without using date format Help
Dear community,
I'm looking for a formula which help extracting date, month & year only from this string "Apr 27, 2021 02:43:17 PM" without using the date format. Please help! Thank you, |
#2
|
|||
|
|||
date =--MID(A1,FIND(" ",A1)+1,FIND(",",A1)-FIND(" ",A1)-1)
month =MID(A1,1,FIND(" ",A1)-1) year =--MID(A1,FIND(",",A1)+2,4) |
#3
|
|||
|
|||
Dear Xor,
Thank you so much for helping. However when I try to put it together so it can be shown as 17/04/2021, it didn't seem to work for me. Is there alternative? Many thanks, |
#4
|
|||
|
|||
Extracting date
See the attached
|
#5
|
|||
|
|||
Extracting date
Use this file instead of the one posted in #4.
|
#6
|
|||
|
|||
Simpler:
=YEAR(DATEVALUE(LEFT$A$1,FIND(",",$A$1)+5))) And the same for day and Month |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Empty date cell shows wrong month & year | Learner7 | Excel | 3 | 06-16-2019 11:09 AM |
Excel day date month year Function | greginky | Excel | 1 | 01-05-2016 02:19 AM |
How to calculate a rolling year-to-date percentage by quarter as the year progresses | sleake | Excel Programming | 2 | 04-23-2015 11:51 AM |
Excel 2013 – need help extracting date and time from text cell plus more. | Art Mann | Excel | 1 | 07-18-2014 09:55 PM |
Letter date changes when merging with Excel - not the format, the actual date! | Smallweed | Mail Merge | 1 | 02-07-2014 06:00 PM |