Help Me Extract 2nd date from Cell

[maximillianrg]

Hello Excel Masters

In Cell A2 I have a formula that extracts the first date it finds in cell L2 and this works great. Now I need to write a similar formula that finds the second date in cell L2 and extracts the date. Can you help?
The below formula finds the 1st "-" and get the date. Not sure how to tell excel to find the 3rd "-" in L2.

Cell A2 Formula: =MID(" "&L2,FIND("-"," "&L2,1)-2,11)
Cell L2 Text: The very first date in this text string is 15-APR-2024 and the status update is 08-DEC-2023 and the stats is
Cell A2 Formula results: 15-APR-2024

 

[DanteAmor]

try

Libro1
	A	B									K	L
1
2	15-APR-2024	08-DEC-2023										15-APR-2024 and the status update is 08-DEC-2023 and the stats is
3
Hoja1

Cell Formulas
Range	Formula
A2	A2	=MID(" "&L2,FIND("-"," "&L2,1)-2,11)
B2	B2	=MID(L2,FIND("-",L2,FIND("-",L2)+10)-2,11)

 

[maximillianrg]

Hello DanteAmor, the formula you provided worked absolutely perfectly and taught me that I need to study the find command in much more detail. In applying the above two formulas I discovered some inconsistencies in the data I'm using that are preventing the formula from working as I need it to si I wanted to ask for some additional help

Lets say L2 now contains the below text.

Deployment schedule ETA: 15-MAR-2024
Deployment Status (Partial/Complete): Temp deployment completed on 28-JUL-2023
Remark: 18-JAN-2024 (CL): Project has

Is it possible to write a formula that
a. finds the first "-" after the word "Remark"
b. extracts "18" before the "-" and "JAN-2024" after the "-"
c. produces the output of 18-JAN-2024

The challenge is I have inconsistencies like extra spaces or missing spaces in the text like below so the formula needs to account for these. I was not able to tweek the formula you created to pull 18-JAN-2024 for all of the below variations

Remark: 18-JAN-2024 (CL): Project has
Remark: 18-JAN-2024 (CL): Project has
Remark:18-JAN-2024 (CL): Project has
Remark:18-JAN-2024 (CL): Project has

The challengs is I may have the

 

[DanteAmor]

Lets say L2 now contains the below text.

Deployment schedule ETA: 15-MAR-2024
Deployment Status (Partial/Complete): Temp deployment completed on 28-JUL-2023
Remark: 18-JAN-2024 (CL): Project has
produces the output of 18-JAN-2024

Try this:

Dante Amor
	A	B	C									L
1	Fisrt Date	Second Date	var
2	15-MAR-2024	18-JAN-2024	1									Deployment schedule ETA: 15-MAR-2024 Deployment Status (Partial/Complete): Temp deployment completed on 28-JUL-2023 Remark: 18-JAN-2024 (CL): Project has
3	15-MAR-2024	18-JAN-2024	2									Deployment schedule ETA: 15-MAR-2024 Deployment Status (Partial/Complete): Temp deployment completed on 28-JUL-2023 Remark: 18-JAN-2024 (CL): Project has
4	15-MAR-2024	18-JAN-2024	3									Deployment schedule ETA: 15-MAR-2024 Deployment Status (Partial/Complete): Temp deployment completed on 28-JUL-2023 Remark: 18-JAN-2024 (CL): Project has
5	15-MAR-2024	18-JAN-2024	4									Deployment schedule ETA: 15-MAR-2024 Deployment Status (Partial/Complete): Temp deployment completed on 28-JUL-2023 Remark:18-JAN-2024 (CL): Project has
6	15-MAR-2024	18-JAN-2024	5									Deployment schedule ETA: 15-MAR-2024 Deployment Status (Partial/Complete): Temp deployment completed on 28-JUL-2023 Remark:18-JAN-2024 (CL): Project has
Hoja1

Cell Formulas
Range	Formula
A2:A6	A2	=MID(" "&L2,FIND("-"," "&L2,1)-2,11)
B2:B6	B2	=MID(L2,FIND("-",L2,FIND("Remark:",L2)+7)-2,11)