Just an annoying niggle I have.
I have 2 rows formatted with a date type. In the 2nd row i've simply put '=A2+7'. So when a date is typed in the first row 7 days is added to it and populated in the second row.
However if there is no value in the first row a value of '07/01/00' is shown in the 2nd row. How can I get a blank value shown when there is no value in the first row?
cheers
I have 2 rows formatted with a date type. In the 2nd row i've simply put '=A2+7'. So when a date is typed in the first row 7 days is added to it and populated in the second row.
However if there is no value in the first row a value of '07/01/00' is shown in the 2nd row. How can I get a blank value shown when there is no value in the first row?
cheers
