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)
--
David Biddulph

"KPR" wrote in message
...
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

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


"KPR" wrote:

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

Worked perfect, Thanks Ron.

"Ron Coderre" wrote:

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


"KPR" wrote:

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

I'm glad that worked for you......and thanks for the feedback!

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

XL2002, WinXP


"KPR" wrote:

Worked perfect, Thanks Ron.

"Ron Coderre" wrote:

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


"KPR" wrote:

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(--TEXT(A1:A9,"mm/dd"))

ctrl+shift+enter, not just enter


"KPR" wrote:

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

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


"Teethless mama" wrote:

=MIN(--TEXT(A1:A9,"mm/dd"))

ctrl+shift+enter, not just enter


"KPR" wrote:

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