ignore blank cells

[Guest]

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]

=min()

it ignores text and empty cells.

or maybe:

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

 

[Guest]

I used this formula and it works great

{=min(if((a1:a10)>0,(a1:a10)))}

Notice though it is an array formula

 

[Dave Peterson]

Since the OP is working with dates, I bet all of the dates are positive <bg>.

Seems like overkill to me.