Convert text date in to a date format excel can read

Hi
Thanks in advance.

I have a text output from another system that displays the date as - Sunday, October 1, 2017 & Monday, October 2, 2017.

Is there a way to convert this to an excel date?

Many thanks
Casey

Do you've PowerQuery installed?
If not maybe someone else will give formula solution

Thanks for the suggestion Sandy.

I have PowerQuery but the people running the macro will not.

There are actually 2 dates in your example. Are these two different examples, or do the dates appear like that in one cell? If so, do you want both dates in two different cells, or just the first date?

Pete

But they can use your result from PQ.
or just convert , copy and paste as values, choose appropriate format and ok

Thanks, that converts it to month & date but is there a way to convert it to the serial date code.

so change format to date format

I'm also confused.

It doesn't allow me to change it to another date format so I assumed the formula just made it text.

I have attached an example

Don't understand the issue

Try the following in F3:

Please Login or Register  to view this content.

See the attached file.

Thanks cbatrody,
That worked perfectly.

Bebo, thanks for picking up on that. When I add +0 it just has a VALUE error.

Thank you all

You are welcome

If that takes care of your question, please mark this thread as Solved by selecting Thread Tools --> Mark thread as solved.