It depends on what the numbers are and what the dates are.

Since dates are really just numbers formatted to look like dates this can be
a problem.

If the numbers are within a certain range, say, 0 to a max of 100, and the
dates are all greater than a certain date then you can try an array formula
like this:

=MAX(IF(C7:BE7100,C7:BE7))

** array formulas need to be entered using the key combination of
CTRL,SHIFT,ENTER (not just ENTER). Hold down both the CTRL key and the SHIFT
key then hit ENTER.

--
Biff
Microsoft Excel MVP


"Ezra" wrote in message
...
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!