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