View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dean
 
Posts: n/a
Default 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