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