Formula help

P

politesse

B1 Has date 12/17/07

Formula below shows 900 in B2 but doesn't change if I delete the date or
change it

=IF(B1>"TODAY()",900,0)

am I missing something

excel 2003

What I am trying to do is have B2 show 900 until date 12/17/07 is reached
then change to 0
 
S

Sandy Mann

Slight change:

To change on the day it should be:

=IF(B1>=TODAY(),900,0)

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

[email protected]
Replace @mailinator.com with @tiscali.co.uk
 
S

Sandy Mann

It does for me. Are you sure that the *Date* in B1 is a real XL Date?

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

[email protected]
Replace @mailinator.com with @tiscali.co.uk
 
P

Peo Sjoblom

Meant to have said

To add to what Sandy just said xxxxxxxxxxxxxxxxxxxxxxxxxxx


Peo
 
Top