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