View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Ezra[_2_] Ezra[_2_] is offline
external usenet poster
 
Posts: 7
Default Min and Max Dates in Range that Contains Zeroes, Dates, and Number

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!