If they are or not?
 

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))<DATEVALUE("11/10/2005"),"Older","Younger")
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 they are or not?
 

=IF(OR(N2<DATE(2005,11,10),T2<DATE(2005,11,10)),"O lder","Younger")
provided N,T columns are formatted like dates.

Regards,
Stefi

€žDean€� ezt Ã*rta:

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))<DATEVALUE("11/10/2005"),"Older","Younger")
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