Converting wonky Date text to date format

[Tipsey]

Good evening,

I am receiving data in the form as an example:

Friday, November 1, 2024 03:11:00 AM

and I need to convert this into a proper date format to perform calculations on.
If anyone has an easy way to do this in a formula that would be great.

Thanks

 

[Phuoc]

Try this:

=INT(TEXTAFTER(A1,", "))

 

[Tipsey]

Awesome, I like yours better than what I was able to come up with:

=LAMBDA(DateText,DATEVALUE(MID(DateText,SEARCH(",",DateText)+1,LEN(DateText)-SEARCH(",",DateText))))