Thread: 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 <75952D62-3DFE-44B1-8A25-DE17F9F60339@microsoft.com>,
"wal50" <wal50@discussions.microsoft.com> 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" <wal50@discussions.microsoft.com> schrieb im Newsbeitrag
news:75952D62-3DFE-44B1-8A25-DE17F9F60339@microsoft.com...
> 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" <wal50@discussions.microsoft.com> schrieb im Newsbeitrag
> news:75952D62-3DFE-44B1-8A25-DE17F9F60339@microsoft.com...
> > 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 <75952D62-3DFE-44B1-8A25-DE17F9F60339@microsoft.com>,
> "wal50" <wal50@discussions.microsoft.com> 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?
>