Why won't my IFAND function work. below are the columns in my worksheet and
example of the data that is in each column. However, my formula is returning
a " " or blank cell instead of the number 1 for dates that are greater than
12/1/2004 and less than 1/1/2006

Function Costcenter
unit date

A B
C D
IF(AND(D212/1/2004,D2<1/1/2006),1,"") 1200120 3465
8/1/2005