Find the MIN of Month and Day only

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,
I have a column of dates with various years and would like to find out the
earliest Day/Month in the column and ignoring the year, how can I do this?

Thanks,
Ken
 
=MIN(DATE(1900,MONTH(A1:A100),DAY(A1:A100))) array entered (Control Shift
Enter)
 
This returns the earliest Month/Day:

=TEXT(MIN(INDEX(--TEXT(A1:A10+(A1:A10=0)*40000,"mmdd"),0)),"00\/00")

Note: What looks like a large "V" is really "\" followed by "/"

Using these values in A1:A10
06/04/2007
06/09/2007
05/30/2010
06/04/2005
06/05/2005
06/06/2005
06/07/2005
06/08/2005
06/09/2005
06/10/2005

the formula returns 05/30

Is that close enough?
***********
Regards,
Ron

XL2002, WinXP
 
Worked perfect, Thanks Ron.

Ron Coderre said:
This returns the earliest Month/Day:

=TEXT(MIN(INDEX(--TEXT(A1:A10+(A1:A10=0)*40000,"mmdd"),0)),"00\/00")

Note: What looks like a large "V" is really "\" followed by "/"

Using these values in A1:A10
06/04/2007
06/09/2007
05/30/2010
06/04/2005
06/05/2005
06/06/2005
06/07/2005
06/08/2005
06/09/2005
06/10/2005

the formula returns 05/30

Is that close enough?
***********
Regards,
Ron

XL2002, WinXP
Click to expand...
 
I'm glad that worked for you......and thanks for the feedback!

***********
Regards,
Ron

XL2002, WinXP
 
I thought it was that easy, too......until I introduced blanks and 02/29/2000
into the data range.

Blanks cause that formula to return 01/01.
02/29/2000 (if it is the lowest value), is converted to 03/01.

(I find it so annoying when computers do what I tell them, instead of what I
meant)
***********
Regards,
Ron

XL2002, WinXP
 
Back
Top