Website Text to date using formula or VBA...

[billyjo182]

I've attached my spreadsheet. I've ran myself in circles for hours now and cannot figure this out. I'm trying to format the date in Column A to mm/dd/yy or dd/mm/yy, either doesn't matter, but I'm scraping the data from a website and need to be able to convert this column to a date.

Can anyone help find what the issue is?

[Akuini]

Do you mean you want data in col A become just date without the time?
If Excel can't evaluate the data in col A as date then it is just text.
And the month name could be different in various regional setting. So I created the month names array.
You need to amend this array to match the month name you get from the web, in this part:

Please Login or Register  to view this content.

then try this code:

Please Login or Register  to view this content.