The macro responds to changes to any cell in the worksheet, we want it to pay attention to only A1.

To avoid hard-coding dates, we usually point the data validation to a list of cells. Where is your list??