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
|