I have a cell (D1) in which a user can enter a date. I have a second cell (
B1) that takes the date from cell
D1 and adds 10 days to it and displays that date.
The user may not need to enter a date in cell D1. When they do not enter a date, Google sheets take the default date from cell
10 and shows
1/9/1900. I would rather have it display
I entered this formula in cell
When there is no date in field
FALSE. When there is a date entered in
D1, the calculation does not happen.
Is the mixing of dates and text not allowed in the same cell? I have the cell formatted as "Automatic"
An example of what I am trying to do is here: