Formula Help!

[MelanieH]

I have an Excel Spreadsheet I am working on. In Column D, I will be posting a date. In Column E, I will be posting the date +2 years.

This is the formula I created:

=DATE(YEAR(D3)+2,MONTH(D3),DAY(D3))

However, if any cells in Column D are blank, Column E produces the number 12/30/1901. I want Column E to remain blank if Column D is blank. How do I do that?

 

[njimack]

=if(d3,date(year(d3)+2,month(d3),day(d3)),"")

 

[MelanieH]

That worked! Thank you so much for your help Neil!