I am having a bit of an issue with being able to pull down my formula from E2 and it not make up a date if the D2 cell is empty. I know I need to put in some kind of a rule that will let the program know that I want it to remain blank if D2 does not have a date, but can't seem to find how. Here is my formula, any help would be greatly appriciated!

=DATE(YEAR(D2)+10,MONTH(D2),DAY(D2))

Try putting IF(D2="","", before "date" in your formula and another closing bracket at the end of the formula.r

Thank you, wonrked like a charm!

Glad to be able to help, Jade :)