I have a date field in a worksheet where the dates are being exported as text into excel. See below.


?*
Aug 28, 2024 05:00 PM (PST)

I need to convert the text to a date. Is there a formula to convert the below to a Date in excel?