If and Dates Clarification
 

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.

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",...


In article ,
"wal50" wrote:

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?

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

--
Regards
Frank Kabel
Frankfurt, Germany
"wal50" schrieb im Newsbeitrag
...
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.

Thanks.
WAL

"Frank Kabel" wrote:

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

--
Regards
Frank Kabel
Frankfurt, Germany
"wal50" schrieb im Newsbeitrag
...
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.

Thanks.
WAL

"JE McGimpsey" wrote:

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",...


In article ,
"wal50" wrote:

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?