Date Formula

[Frank]

I have the following formula in a cell that is referencing
B31 (a date field). Can anybody tell me why this does not
work. I have tried over and under etc etc.

In other words if I input 01/01/2003 the result does not
change???

=IF($B$31>1/15/2003,0,D21)

Thanks
Frank

 

[JohnI]

Frank,

try

=IF($B$31>DATEVALUE("15-Jan-2003"),0,D21)

What you are getting at the moment is:-

1 divided by 15 divided by 2003 giving a result of0.0000332834082210018

which is not what you're after. Remember slash is for division.

Dates in IF tests have to be converted using a function.

regards,

JohnI

 

[jr]

try:
=IF($b$31>DATEVALUE("1/15/2003",0,D21)

 

[Frank]

Thanks John

Perfect

Frank

-----Original Message-----
Frank,

try

=IF($B$31>DATEVALUE("15-Jan-2003"),0,D21)

What you are getting at the moment is:-

1 divided by 15 divided by 2003 giving a result of0.0000332834082210018

which is not what you're after. Remember slash is for division.

Dates in IF tests have to be converted using a function.

regards,

JohnI





.