=IF(DAY(TODAY())=15,100,"")

Vaya con Dios,
Chuck, CABGx3




"Brian" wrote in 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