how do you ignore blank cells
 

I am trying to write a formula that results in the earliest date but a blank
cell results in a 0.
=MIN('1Jan-9Jan'!R196,'10Jan-16Jan'!R196,'17Jan-23Jan'!R196)
What do I need to do to this formula to ignore blank cells

This is the idea. Modify this array formula to suit your needs. An array
formula must be entered/edited using control+shift+enter vs just enter

=MIN(IF(A1:A100,A1:A10))

--
Don Guillett
SalesAid Software

"Kerry" wrote in message
...
I am trying to write a formula that results in the earliest date but a
blank
cell results in a 0.
=MIN('1Jan-9Jan'!R196,'10Jan-16Jan'!R196,'17Jan-23Jan'!R196)
What do I need to do to this formula to ignore blank cells