Solved

Finding the oldest date in a column with the following date format....

Posted on 2013-06-14
4
421 Views
Last Modified: 2013-06-15
My column has the following format.  I tried min and small to find the oldest date but it did not work.  I tried formatting the column to date as well.


2013-06-13 22:31:00.000


Thank you.
0
Comment
Question by:dorianit
4 Comments
 
LVL 15

Assisted Solution

by:Ess Kay
Ess Kay earned 167 total points
ID: 39248516
use this tecnique

http://www.techonthenet.com/excel/questions/remove_time.php


needless to say, change the / into a -
0
 
LVL 92

Assisted Solution

by:Patrick Matthews
Patrick Matthews earned 166 total points
ID: 39249037
If those are actually text values, then try this:

{=MIN(VALUE(E2:E1000))}

Apply appropriate date number formatting.

That's an array formula.  Do not type the curly braces, and use Ctrl+Shift+Enter to finish it off.
0
 
LVL 50

Accepted Solution

by:
barry houdini earned 167 total points
ID: 39249262
Try using "text to columns" to convert to "real" date/time values

Select column > Data > text to columns > Finish

Now try using MIN again and that should work.......

regards, barry
0
 

Author Comment

by:dorianit
ID: 39250297
Because the data was from a query,  I found that I could just sort the column and figure out the oldest date that way.  With subsequent queries the, column sorts would remain sorted.
0

Featured Post

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

As with any other System Center product, the installation for the Authoring Tool can be quite a pain sometimes. This article serves to help you avoid making these mistakes and hopefully save you a ton of time on troubleshooting :)  Step 1: Make sur…
Recently Microsoft released a brand new function called CONCAT. It's supposed to replace its predecessor CONCATENATE. But how does it work? And what's new? In this article, we take a closer look at all of this - we even included an exercise file for…
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question