Minimum Date Range from other cells

I have several seperate excel files where people enter a specific date
I then have a seperate excel file that captures the date from the other files mentioned above. From this file I need to capture the oldest date. Not everyone is required to enter a date if they have nothing to report however there will always be a date in cell I4 (see below)

Please Login or Register  to view this content.

The problem is if I have nothing in any of the other cells three cells, it returns a value of 0. I need to know how to ignore the values if any of the cells are blank.

I have included a screenshot of what I'm doing. Any help would be great as I'm sure this is an easy question.

Thanks
James

=MIN(IF(N(INDIRECT({"I4";"L4";"R4";"X4"}))<>0,N(INDIRECT({"I4";"L4";"R4";"X4
"}))))

It is an array formula, so commit with Ctrl-Shift-Enter.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"JLT" <[email protected]> wrote in message
news:[email protected]...
>
> I have several seperate excel files where people enter a specific date
> I then have a seperate excel file that captures the date from the other
> files mentioned above. From this file I need to capture the oldest
> date. Not everyone is required to enter a date if they have nothing to
> report however there will _always_ be a date in cell I4 (see below)
>
>
> Code:
> --------------------
> =MIN(I4,L4,R4,X4)
> --------------------
>
>
> The problem is if I have nothing in any of the other cells three cells,
> it returns a value of 0. I need to know how to ignore the values if any
> of the cells are blank.
>
> I have included a screenshot of what I'm doing. Any help would be
> great as I'm sure this is an easy question.
>
> Thanks
> James
>
>
> +-------------------------------------------------------------------+
> |Filename: excel help.jpg |
> |Download: http://www.excelforum.com/attachment.php?postid=4171 |
> +-------------------------------------------------------------------+
>
> --
> JLT
> ------------------------------------------------------------------------
> JLT's Profile:
http://www.excelforum.com/member.php...o&userid=30042
> View this thread: http://www.excelforum.com/showthread...hreadid=497259
>