LinkBack URL
About LinkBacks
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
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
Last edited by LittleMzBiteMe; 06-21-2016 at 01:59 PM. Reason: Adding Excel Worksheet
Perhaps add an excel file, i am not able to open PNG files.
Please Login or Register to view this content.
Last edited by JBeaucaire; 06-21-2016 at 01:51 PM.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
The values in I:J do not appear to be valid dates. 12/16/15 is not the same 12.16.15.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
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))
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))
Holy moley! All that instead of simply reverting to standard date formats?
I applaud the dedicated response, and immediately recommend standard date formats.
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
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!!!!!
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
Maybe:
=DATEVALUE(SUBSTITUTE(I25, ".", "/"))
Do Find/replace "." with "/"
Select column I
Text-to=Columns>>Next twice==>Date ->MDY ==> Finish
Repeat for J
Last edited by JohnTopley; 06-21-2016 at 02:33 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks