E
Ezra
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!
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!