Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

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

Posted on 2013-06-14
4
Medium Priority
?
455 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 668 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 93

Assisted Solution

by:Patrick Matthews
Patrick Matthews earned 664 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 668 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

NFR key for Veeam Agent for Linux

Veeam is happy to provide a free NFR license for one year.  It allows for the non‑production use and valid for five workstations and two servers. Veeam Agent for Linux is a simple backup tool for your Linux installations, both on‑premises and in the public cloud.

Question has a verified solution.

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

Microsoft's Excel has many features that most people will never need nor take advantage of.  Conditional formatting is one feature that you may find a necessity once you start using it.
Outlook for dependable use in a very small business   This article is about using the Outlook application (part of Microsoft Office) in a very small business, or for homeowners where dependability and reliability are critical requirements. This …
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.
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…

782 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