Actually, it's for a budget worksheet, so I need it to occur every month,
but I can adjust you're formula accordingly.
Thanks.
"Biff" wrote in message
...
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


.