Dates and IF Functions

[Happysapper]

Hi, I'm compiling a competency register with a "date of test taken" in one
column, and the next column takes that vale and adds 6 months.

I have mastered the straightforward business of adding the 6 months; but
what i can't prevent is the answer of "29/06/1900" appearing in those cells
where i have yet to enter a value for the "date of test taken".

When i tried an IF function using the date formula as one of the "values if
true" the cells displayed the formula and not the answer.

Thanks

HS

 

[Eduardo]

Hi,
you can fix the 29/06/1900 from appearing with an if statement

if(A1="","",A1+60)

A1= cell where you enter the date