Formula help

[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

 

[Guest]

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

 

[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

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk

 

[politesse]

ok then, why don't it change if I change the date to yesterday

 

[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

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk

 

[Peo Sjoblom]

If it is text B1 will always be greater

 

[Peo Sjoblom]

Meant to have said

To add to what Sandy just said xxxxxxxxxxxxxxxxxxxxxxxxxxx


Peo

 

[politesse]

Did a repair on excel and now it works. go figure! Thanks for all the help