software

I am trying to use a function that will find the earliest date in a wide
range of dates. I have tried using =MIN(A1:A455) but it returns 0-Jan-00.
There are no spaces in the range.

I bet you have a 0 in that range.

It could be hidden by formatting (or conditional formatting), but it's there.

If you select A1:A455 and edit|find
search for 0
(Match entire cell contents)
you may find it
(or search for 0-jan-00 if it may be formatted as a date)

If it turns out you have to leave the 0's in your data, you can use a different
formula to ignore them:

=MIN(IF(a1:a455gt;0,a1:a455))

This is an array formula. Hit ctrl-shift-enter instead of enter. If you do it
correctly, excel will wrap curly brackets {} around your formula. (don't type
them yourself.)

Adjust the range to match--but you can't use the whole column.

====
But I'd do my best to clean the data.

Rachel Williams wrote:
gt;
gt; I am trying to use a function that will find the earliest date in a wide
gt; range of dates. I have tried using =MIN(A1:A455) but it returns 0-Jan-00.
gt; There are no spaces in the range.

--

Dave Peterson

Ps. That 0 could be on a hidden row, too???

Dave Peterson wrote:
gt;
gt; I bet you have a 0 in that range.
gt;
gt; It could be hidden by formatting (or conditional formatting), but it's there.
gt;
gt; If you select A1:A455 and edit|find
gt; search for 0
gt; (Match entire cell contents)
gt; you may find it
gt; (or search for 0-jan-00 if it may be formatted as a date)
gt;
gt; If it turns out you have to leave the 0's in your data, you can use a different
gt; formula to ignore them:
gt;
gt; =MIN(IF(a1:a455gt;0,a1:a455))
gt;
gt; This is an array formula. Hit ctrl-shift-enter instead of enter. If you do it
gt; correctly, excel will wrap curly brackets {} around your formula. (don't type
gt; them yourself.)
gt;
gt; Adjust the range to match--but you can't use the whole column.
gt;
gt; ====
gt; But I'd do my best to clean the data.
gt;
gt; Rachel Williams wrote:
gt; gt;
gt; gt; I am trying to use a function that will find the earliest date in a wide
gt; gt; range of dates. I have tried using =MIN(A1:A455) but it returns 0-Jan-00.
gt; gt; There are no spaces in the range.
gt;
gt; --
gt;
gt; Dave Peterson

--

Dave Peterson