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

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.
dorianitAsked:
Who is Participating?
 
barry houdiniCommented:
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
 
Ess KayEntrapenuerCommented:
use this tecnique

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


needless to say, change the / into a -
0
 
Patrick MatthewsCommented:
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
 
dorianitAuthor Commented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.