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


"Sandy Mann" wrote in message
...
Slight change:

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

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


Replace @mailinator.com with @tiscali.co.uk


"Toppers" wrote in message
...
=IF(B1TODAY(),900,0)


"politesse" wrote:

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