Sorting inconsistent dates

[thisandthat]

I'm trying to write a macro that sort how much time someone works on a date.
I get sheets that show a date, a job and then how many hours worked

Problem is that everything is formatted as "General" as well I get different formats,

For example Friday November 30th 2018 could come in as:

Friday 11/30/2018
Fri 30/11/2018 2:00 PM
30/11/2018
December 30 2018
etc
etc

Basically they are copied from outlook journals....so whatever someone has set up in there.

How can I standardize that?

Currently I have it working with Fri 30/11/2018 2:00 PM format.

I just remove the "Fri" and the "2:00 pm" then sort unique values.

I'm a pretty basic VBA programmer and a push in the right direction would be great.

Thanks

[dflak]

I suggest using a helper column with the formula =IF(ISNUMBER(A2),A2,DATEVALUE(A2)) assuming the dates you want are in column A.

[dflak]

In fact, if you just want to work with whole dates use: =INT(IF(ISNUMBER(A2),A2,DATEVALUE(A2))).

DateValue will give you a whole date. The INT will strip off the time piece it A2 actually is a date.

[thisandthat]

DATEVALUE Returns an error
the cell is formatted as

Tue 12/04/2018 12:45 PM

I've also tried

Please Login or Register  to view this content.

But doesn't work with the format I'm using. I must be missing a formatting concept.

Thanks

[mjr veverka]

... Problem is that everything ... get different formats ...

... the cell is formatted as

Tue 12/04/2018 12:45 PM

This is no problem ... this is ... nightmare ...

This date 12/04/2018 - this is April or December ?
Fortunately, there is the entry "Tue", then this is December ... but what if, in April and in December, it would be the same day of the week ?
It could happen, it is not impossible.
And what about such dates (if such were in sample), for example: 7/6/2018 and 6/7/2018, both dates without the given day of the week ?
How to recognize a month here if, like you write, the date formats are different ?

Based on this small data sample, this can be referred to as:
... highly disturbing with elements of exceptional dislocation of the possibilities of considering possibilities ... ... or something similar ...

... How can I standardize that? ...

Attach a larger sample of data, maybe someone will come up with something.

[thisandthat]

Gotcha,

Well I'll just get everyone to enter consistent formats with their time sheets and go from there.

Thanks