Hi!

On the 15th of which month? Also, after the 15th do want
this value to be permanent?

In D6 enter this formula:

=IF(TODAY()=DATE(2005,2,15),100,"")

On Feb 15 2005 the cell will populate with the value 100.

Biff

-----Original Message-----
I want to have a cell populate with a specific value once
a particular date
coemes.

Example: On the 15th of the month I want to have cell D6
populate with the
value 100.

THanks


.