Hi Jeff,

I don't experience the problem you outline. I have both advanced my PC date to check this, and also, but independently advanced the date in column D to > today. In both cases the macro works as you require.

Are you sure you have created this in the Worksheet_Change event?
If so, can you upload your version of the workbook so we can take a look?


Rgds