software

It's another if question.

I have two datetime columns that I want to know if the date in them is older
than 11/10/05 or #N/A.
Currently I have another column for each that says
=IF(INT(LEFT(T8,10))lt;DATEVALUE(quot;11/10/2005quot;),quot;Olderquot;,quot;Youngerquot;)
The other date column is (N).
but I want this for both the columns, in one answer.
The info in each of the columns is either #N/A or a datetime anywhere in the
past few years, some of the rows will both be #N/A, some with both be dates.
If any are dates then I want to know if either are older than 11/10/05.

Thanks
Dean

=IF(OR(N2lt;DATE(2005,11,10),T2lt;DATE(2005,11,10)),quot;O lderquot;,quot;Youngerquot;)
provided N,T columns are formatted like dates.

Regards,
Stefi

?ean??ezt ?rta:

gt; It's another if question.
gt;
gt; I have two datetime columns that I want to know if the date in them is older
gt; than 11/10/05 or #N/A.
gt; Currently I have another column for each that says
gt; =IF(INT(LEFT(T8,10))lt;DATEVALUE(quot;11/10/2005quot;),quot;Olderquot;,quot;Youngerquot;)
gt; The other date column is (N).
gt; but I want this for both the columns, in one answer.
gt; The info in each of the columns is either #N/A or a datetime anywhere in the
gt; past few years, some of the rows will both be #N/A, some with both be dates.
gt; If any are dates then I want to know if either are older than 11/10/05.
gt;
gt; Thanks
gt; Dean