Hi
I have been using basic excel functions for a while now, and in the last two weeks have learnt some of the validation, conditional formatting functions available, I am learning how the vba code is written, but this is going to be a long process, i have created a spreadsheet that tracks main parts of a process,using conditional formatting to highlight overdue dates, and highlighting the parts of the process green once completed, my question is, is there a way of using a macro rather than a formula if I want cell b1 to show a date of 7days later than the entered date in cell a1

I know the formula entered in b1 is =a1+7 as a formula, but as the dates are not always entered in column a in order this poses a problem, if i copy the formula down column b and have no date in column a it shows the 07-01-1900 date, I know why this happens, but i want the formula in the cells of column b but not showing anything until a date is entered in column a.

can anyone help