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 D1
adds 10
and shows 1/9/1900
. I would rather have it display N/A
.
I entered this formula in cell B1
.
=D1+10=IF(D1="12/30/1899","N/A","")
When there is no date in field D1
, B1
displays 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:
https://docs.google.com/spreadsheets/d/16o7uli52NCyFxrEWHvIbTq19Y9H8uld-s2GUrrRjUnY/edit?usp=sharing