software

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: www.excelforum.com/attachment.php?postid=4171 |
-------------------------------------------------------------------

--
JLT
------------------------------------------------------------------------
JLT's Profile: www.excelforum.com/member.php...oamp;userid=30042
View this thread: www.excelforum.com/showthread...hreadid=497259
=MIN(IF(N(INDIRECT({quot;I4quot;;quot;L4quot;;quot;R4quot;;quot;X4quot;}))lt;gt;0,N(IN DIRECT({quot;I4quot;;quot;L4quot;;quot;R4quot;;quot;X4
quot;}))))

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

--

HTH

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