Slice system date field and convert to US dates

[rpinxt]

Please see attached workbook.
It contains a column in which I have system dates/times.
The column is part of a bigger file but my question is only about this column.

Its gives : Date (in european settings) Time AM/PM Timezone.
But all in 1 cell!!

What I want now is in the column next to it or wherever that the macro give the date for that line.

Second thing is that the dates are in Dutch months.
I would need it to give the US months.

So instead of Mei it should give May, Mar instead of Mrt and Oct instead of Okt.

A further nice to have would be that it then in another column give the correct weeknumber.
Thanks.

[dflak]

What format do you want it in? 5/2/7? or 02-May-2017? Do you care about the time or just the dates?

I can come up with a string that looks like the date format you want, and I can compute the date as a number, but your regional settings will turn them back to a European display.

[rpinxt]

Well dflak actually this how I now solved it :

Please Login or Register  to view this content.

But could be there are easier and quicker ways.
As you see I did a text to column to isolate only the date part of the text string.
After that still a few things were necessary to make it recognize the correct dates.

ps: This is code from the bigger workbook so that is why the column letters don't add up with the sample book.

[rpinxt]

Ok....turns out this solution is not working...

Noticed now for example 10-3-2017 is showing as 3 October where it should be 10 March

These dates settings are driving me crazy.

[rpinxt]

Found that replacing first to american names works better than using the month numbers.

Now this code makes the date field usable for further processing:

Please Login or Register  to view this content.

Think i will close the thread.

[jindon]

Try

Please Login or Register  to view this content.

Don't worry about this, if you find the solution already.