Format formula to date?

[288enzo]

Hi all,

I have a spreadsheet that is exported from a database. What I have to work with in particular is cell C3 formatted as General. I have created a helper column D and used the following formula to extract the date.
C3 is

5/7/2024 9:30:00 AM

D3 is

=LEFT(C3,FIND(" ",C3)-1)

What I can't figure out and need your assistance with is how to format D3 to "Date" and specifically the example "Wednesday, March 14, 2012" as shown in Format Cells. When I try, nothing happens.
Thank you

 

[Cubist]

Try to apply =DATEVALUE(...) then Ctrl + 1 -> Number -> Custom insert dddd, mmmm dd, yyyy

 

[288enzo]

Try to apply =DATEVALUE(...) then Ctrl + 1 -> Number -> Custom insert dddd, mmmm dd, yyyy

Boom goes the dynamite. Thank you very much!