Only calculate formula if cell is not blank

[MonicaAS]

In one column I have a date field. If there is no date I don't want the other columns to calculate the formula, using VBA.
Column c: 1/20/20 Column D: "formula is column c +21 days column E: "column d minus today.
its all based on the date field in column C.

 

[Joe4]

Thank you. I will download it later tonight when I am at my home computer and take a look.

 

[Joe4]

The issue appears to be that you already have columns D and E populated down to the last row of data. So it is not recognizing that there is any new data that this needs to be run on.

 

[MonicaAS]

Thank you that worked. it's always the small things that trip me up.

 

[Joe4]

You are welcome.

 

[MonicaAS]

question. the code is running great however if we go back and add a comment, it won't delete the cell with the days left. I have to clear out the date in the due date column, then update it. is there something i can add so i don't have to clear the contents out of the due date column?

 

[Joe4]

question. the code is running great however if we go back and add a comment, it won't delete the cell with the days left. I have to clear out the date in the due date column, then update it. is there something i can add so i don't have to clear the contents out of the due date column?

As that is a new question, it is probably best to start a new thread on it.
In the new question, I would recommend posting your most current copy, and a copy of the workbook (and/or pertinent screen images) so whoever answers can see exactly what it is you are working with.