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
Bookmarks