If and Dates Clarification

[Guest]

Having a bit of trouble with this: =IF(D2<12/13/04, " ", A2).

Column D has dates (formatted mm/dd/yy). Dates are before and after
12/13/04 but the above statement always a blank and
=IF(D2> 12/13/04, " ", A2) always returns the value in A.
If I put 12/13/04 in a cell (H2) and use =IF(D7<$H$2," ", A7), it works.
What did I do wrong in the first one?

Thanks.

 

[JE McGimpsey]

Your conditional,

D2<12/13/04

will be interpreted as

D2 is less than 12 divided by 13 divided by 14 (i.e., 0.230769231).

Use either

=IF(D2<DATE(2004,12,13),...

or

=IF(D2<"12/13/04",...

 

[Frank Kabel]

Hi
use
=IF(D1<DATE(2004,12,13),"",A2)

 

[Guest]

Thanks.
WAL

Hi
use
=IF(D1<DATE(2004,12,13),"",A2)

 

[Guest]

Thanks.
WAL

Your conditional,

D2<12/13/04

will be interpreted as

D2 is less than 12 divided by 13 divided by 14 (i.e., 0.230769231).

Use either

=IF(D2<DATE(2004,12,13),...

or

=IF(D2<"12/13/04",...