DisplayName
New Member
- Joined
- May 24, 2017
- Messages
- 10
Hello - I have several cell that contain dates in text format. I'm trying to extract the dates from those cells & return values as a date format, preferably (Jun-19) format. Below is an example: I'm using =MID(A1,FIND("/",A1)-2,5) to extract -6/18, and then =SUBSTITUTE(B1,"-","") to get rid of the -. Ultimately I want it to return the value in this date format (Jun-18). Please haaalp!
LAHSA G391-6/18 REV
07/18 GRANT REV 391
LAHSA G391-7/18 REV
08/18 GRANT REV 391
LAHSA G391-8/18 REV
09/18 GRANT REV 391
LAHSA G391-9/18 REV
10/18 GRANT REV 391
LAHSA G391-10/18 REV
11/18 GRANT REV 391
LAHSA G391-11/18 REV
12/18 GRANT REV 391
LAHSA G391-12/18 REV
01/19 GRANT REV 391
LAHSA G391-1/19 REV
02/19 GRANT REV 391
LAHSA G391-2/19 REV
03/19 GRANT REV 391
04/19 GRANT REV 391
05/19 GRANT REV 391
LAHSA G391-6/18 REV
07/18 GRANT REV 391
LAHSA G391-7/18 REV
08/18 GRANT REV 391
LAHSA G391-8/18 REV
09/18 GRANT REV 391
LAHSA G391-9/18 REV
10/18 GRANT REV 391
LAHSA G391-10/18 REV
11/18 GRANT REV 391
LAHSA G391-11/18 REV
12/18 GRANT REV 391
LAHSA G391-12/18 REV
01/19 GRANT REV 391
LAHSA G391-1/19 REV
02/19 GRANT REV 391
LAHSA G391-2/19 REV
03/19 GRANT REV 391
04/19 GRANT REV 391
05/19 GRANT REV 391
