Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |