Excel - Autofilling dates

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 cannot seem to find
how. Here is my formula, any help would be greatly appriciated!

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




--
Jade Summers

Jade Summers;1603214 Wrote:

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




--
Spencer101

Spencer101;1603216 Wrote:

Thank you, wonrked like a charm!




--
Jade Summers

Jade Summers;1603490 Wrote:

Glad to be able to help, Jade :)




--
Spencer101