Max Date for Row - but not working - 01/00/00 result - what am I doing wrong?

[LittleMzBiteMe]

The columns are all formatted the same, and I've tried different formats as dates, text, general - I can't figure out what I'm doing wrong, but I'm not great at Excel either

Capture.PNG

[oeldere]

Please Login or Register  to view this content.

Perhaps add an excel file, i am not able to open PNG files.

[JBeaucaire]

The values in I:J do not appear to be valid dates. 12/16/15 is not the same 12.16.15.

[Jdevil]

You could possibly add helper columns somewhere if you do not wish to change your format.. If that helps

With formula =DATE(RIGHT(I25,2),LEFT(I25,2),MID(I25,4,2))

[Jdevil]

Actually that could work:
=MAX(DATE(RIGHT(I25,2),LEFT(I25,2),MID(I25,4,2)),DATE(RIGHT(J25,2),LEFT(J25,2),MID(J25,4,2)),DATE(RIGHT(K25,2),LEFT(K25,2),MID(K25,4,2)),DATE(RIGHT(L25,2),LEFT(L25,2),MID(L25,4,2)),DATE(RIGHT(M25,2),LEFT(M25,2),MID(M25,4,2)),DATE(RIGHT(N25,2),LEFT(N25,2),MID(N25,4,2)),DATE(RIGHT(O25,2),LEFT(O25,2),MID(O25,4,2)),DATE(RIGHT(P25,2),LEFT(P25,2),MID(P25,4,2)),DATE(RIGHT(Q25,2),LEFT(Q25,2),MID(Q25,4,2)),DATE(RIGHT(R25,2),LEFT(R25,2),MID(R25,4,2)),DATE(RIGHT(S25,2),LEFT(S25,2),MID(S25,4,2))

[JBeaucaire]

Holy moley! All that instead of simply reverting to standard date formats?

I applaud the dedicated response, and immediately recommend standard date formats.

[LittleMzBiteMe]

I did play with the formatting - tried all columns as traditional date formatting, but still receive the 01/00/00 or 01.00.00 result

[LittleMzBiteMe]

I have to actually go into each cell and retype it in the date format after selecting the traditional date format for the cell. lol
Not fun, but at least it works!!! Thank you all so much for holding my hand through this, I greatly appreciate it!!!!!

[Jdevil]

Surely you can avoid doing that, at least use the first formula I provided and drag it down then copy and paste as values, doing all of that manually can take long if you have lots of data

[JBeaucaire]

Maybe:

=DATEVALUE(SUBSTITUTE(I25, ".", "/"))

[JohnTopley]

Do Find/replace "." with "/"

Select column I

Text-to=Columns>>Next twice==>Date ->MDY ==> Finish

Repeat for J