Solved

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

Posted on 2013-06-14
4
427 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

Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

Question has a verified solution.

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

Technology opened people to different means of presenting information, but PowerPoint remains to be above competition. Know why PPT still works today.
Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

821 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