Extract date from text

[gromden]

I am trying to figure out how to extract a date from a text cell but not sure how to modify the formula when the date is single number (1, 2, etc) vs a two digit number (12, 13, etc) as the data I am extracting is in text format vs date format.
The date would look like:
Dec 1, 2024, 12:13:12 PM
Dec 10, 2024, 1:00:14 PM
I don't really need the time so I have been using =INT(LEFT(D186, 11) or =INT(LEFT(D186, 12) but would prefer one formula rather than having to modify it every time I paste in new data. Column D is where the date is in.

If anyone has any pointers, would be appreciated! Thanks.

 

[etaf]

how about as you have 365
=TEXTBEFORE(D186, ",", 2)

BUT i dont see why
=INT(LEFT(D186, 11)
would work - as its TEXT

did you want to change to a real date ?

 

[gromden]

Ahh I realized I don't really need INT since it is text. I did try what you suggested and it did work. Thanks for that.
If I did want to convert to a real date, what do you suggest?

 

[Joe4]

Ahh I realized I don't really need INT since it is text. I did try what you suggested and it did work. Thanks for that.
If I did want to convert to a real date, what do you suggest?

Wrapping the function in INT (like you had) or DATEVALUE will convert it to a real date.
Then just choose your desired date format for the cell.

 

[gromden]

Wrapping the function in INT (like you had) or DATEVALUE will convert it to a real date.
Then just choose your desired date format for the cell.

Thank you. That worked.