Help with Formulas containing text and dates

[Felicia Melocoton]

Working with Formulas with text and dates

I have 7 columns. On the 5th column that says Date Completed, If I enter a date on this column, for example 01/22/05, I would like the next column which is the pass/Fail column to give me the result as pass

example:
01/22/05 = Pass

 

[Aladin Akyurek]

Working with Formulas with text and dates

I have 7 columns. On the 5th column that says Date Completed, If I enter a date on this column, for example 01/22/05, I would like the next column which is the pass/Fail column to give me the result as pass

example:
01/22/05 = Pass

In Q2 enter:

=ISNUMBER(P2)+0

where P2 a Date Completed cell and Q2 a Fail/Pass cell.

Custom format Q2 as:

[=0]"Fail";[=1]"Pass"

 

[Felicia Melocoton]

No, Formula does not work.

 

[Aladin Akyurek]

No, Formula does not work.

What result do you get?

Also, care to give examples where Fail and Pass would be the results?

 

[KenWright]

Works fine for me, assuming a blank entry means "fail" until a date is entered which will make it a "pass".

 

[Felicia Melocoton]

Yes, Ken that is exactly the answer that I am looking for.

If there is no entry date on the Date Completed it is a Fail, If there is an entry date on the Date Completed it is a Pass.

Please help me with the formula.
Thanks