Dates and IF Functions

  • Thread starter Thread starter Happysapper
  • Start date Start date
H

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
 
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
 
Back
Top