How to hide date 01/10/1900 for calculating dates

Hello,

I have the following:

Start Date: D15 (Formatted as date)
Due Date: E15 (Formatted as date) with following formula: =(DATE(YEAR(D15),MONTH(D15),DAY(D15)+10))
As you can see it adds 10 days to the due date.

This works great if there is a date in D15, however if there is no date I get the 1/10/1900. How do I hide this? I have tried custom formatting dd/mm/yyyy;; which didn't work.

I was thinking of doing an if statement, but I am sure I am doing it wrong since I am getting an error in the cell.

Ideally I would like for it to be blank until there is a date entered in D15.

Also, I have no issue with changing the formula, this is how I have done it in the past, but if there is an easier way in order to hide the 1/10/1900 date, I am all for it!

Thanks

maybe add an IF statement to it, something like ... =IF(D15="","",(DATE(YEAR(D15),MONTH(D15),DAY(D15)+10)))
(untested)

=IF(D15="", "",D15+10)

it will add days without all of the formattings.

glad it worked for you AND thanks for the rep!