I've read the other posts about finding the earliest date in a row.
However, in my case, I have 20 columns of dates in the row.
The first column does not necessarily contain the earliest date.
Once there is no legitimate date for a column, the remaining columns
are filled with 1/0/1900 (zero).
Using =MIN(range) always produces 0.
Example of data:
<tbody>
</tbody>
Your assistance is greatly appreciated.
However, in my case, I have 20 columns of dates in the row.
The first column does not necessarily contain the earliest date.
Once there is no legitimate date for a column, the remaining columns
are filled with 1/0/1900 (zero).
Using =MIN(range) always produces 0.
Example of data:
9/9/2004 | 9/14/2004 | 9/8/2004 | 1/0/1900 | 1/0/1900 |
<tbody>
</tbody>
Your assistance is greatly appreciated.