=min()

it ignores text and empty cells.

or maybe:

=if(count(a1:a10)=0,"No Numbers",min(a1:a10))



Leticia wrote:

Hello,

Im using the formula MIN to select the minimun date of a columm, but in that
colum there are several blank cells that must keep blank. Which formula could
i use to ignore the blank cells ans selecct the minimun date?

Thank u!!!!

Leticia

--

Dave Peterson