Jacob:

Worked like a charm! I've tested a few combos of entries in different cells,
and so far, it seems to return the correct result each time. Thank you so
much! I must admit that I always have trouble wrapping my brain around array
formulas, and I doubt I would have come up with this EVER. Thanks!

"Jacob Skaria" wrote:

Try the below. Please note that this is an array formula. Within the cell in
edit mode (F2) paste this formula and press Ctrl+Shift+Enter to apply this
formula. If successful in 'Formula Bar' you can notice the curly braces at
both ends like "{=<formula}"

=MIN(IF(ISNUMBER(C7:BE7),IF(YEAR(C7:BE7)1900,C7:B E7)))

If this post helps click Yes
---------------
Jacob Skaria


"Ezra" wrote:

I just can't figure this one out. In Row 7, have a range from Column C to
Column BE that contains cells containing numbers, cells containing dates, and
cells containing text. There may be zeroes, the date equivalent of zero, or
blank cells in each. Is there a formula that will return the value of the
minimum date in the range, disregarding the "zeroes" in date cells and
disregarding the cells containing numbers and text?

Many thanks in advance for any suggestions!