Comparing Excel Dates

  • Thread starter Thread starter Dashman
  • Start date Start date
D

Dashman

I have a list in which I want to find similar dates and times in a column and
extract the earliest date/time. I have been manually sorting the date/time
column and copying the earlier listing to another area of my workbook. The
format in the cells are in date/time (i.e. 11/21/2006 3:13:55 PM). There are
always hundreds of records to sift through. Is there a combination of
functions and/or VBA that I could use to compare dates/times and extract the
earlier of the same dates.
Thanks in advance for your help.
 
Hi Dashman:

Luckly, date/times compare just like ordinary numbers. So if you have
date/times in column A, then

=MIN(A1:A100) formatted properly will give the earliest date/time
 
Gary...

Thanks for the response but this a little bit more complex than that... I
don't want the earliest of all the dates. I want the earliest date/time of
comparable entries. For example I might have 3 records with the same date
but different times. I want to be able to extract the earliest of those 3
date/time entries but I also want to do that at the same time for the entire
list. Those 3 records are some of many records. I should also add that the
date/time entries are based on groups of another field such as a transaction
number. The goal is to extract the earliest date/time of records for the
same transaction number each time that number is repeated. Hope that makes
sense.
Thanks.
 
Shane...

Here is an example..

Status Status Date Job ID Recruiter Original Date Posted
New Record 11/7/2006 11:57 163 Admin ZZ- SR 5/23/2004 19:41
New Record 11/7/2006 11:57 163 Admin ZZ- SR 5/23/2004 19:41
New Record 7/18/2007 15:35 599 Admin ZZ- SR 7/19/2006 8:52
New Record 7/18/2007 15:36 599 Admin ZZ- SR 7/19/2006 8:52
New Record 8/9/2006 14:40 174 Admin ZZ- SR 7/13/2004 12:13
New Record 8/9/2006 14:41 174 Admin ZZ- SR 7/13/2004 12:13

Thanks
 
Shane...

Here is an example...
Status Status Date Job ID Recruiter Original Date Posted
New Record 11/7/2006 11:57 163 Admin ZZ- SR 5/23/2004 19:41
New Record 11/7/2006 11:57 163 Admin ZZ- SR 5/23/2004 19:41
New Record 7/18/2007 15:35 599 Admin ZZ- SR 7/19/2006 8:52
New Record 7/18/2007 15:36 599 Admin ZZ- SR 7/19/2006 8:52
New Record 8/9/2006 14:40 174 Admin ZZ- SR 7/13/2004 12:13
New Record 8/9/2006 14:41 174 Admin ZZ- SR 7/13/2004 12:13
 
Back
Top