Dates and IF Functions

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
 
E

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

IF Function with Dates 9
If functions and dates 4
IF Dates 1
Use if functions with dates 1
Figuring Dates quit working! 2
Conditional formatting with expired dates after current 1
subtracting 2 dates and put the result in difference in months ? 2
Combining functions: Subtraction and IF 1

Top