excel

[Guest]

Hi,
I have a column which contains dates, i want to get a result of " done" in
the column next to it if any date is available , or "outstanding" if the
there is no date.
Thanks

 

[JE McGimpsey]

Assuming the dates in column A, one way:


B1: =IF(A1="","outstanding","done")

 

[Guest]

Not clear,
Assume
the result:
coulm a coulm b
12-8-2004 Done
13-8-2004 Done
NA not done
NA not done

IE : ANY DATE SHOWN IN COLUM A , SHOULD GET A RESULT WITH "DONE" & IF THERE
IS NO DATE , GET A RESULT WITH "NOT DONE"

THANK YOU VERY MUCH

 

[Dave Peterson]

Dates are just numbers to excel. Maybe you can use that:

=if(isnumber(a1),"done","not done")

 

[Guest]

Thank you very much

Dates are just numbers to excel. Maybe you can use that:

=if(isnumber(a1),"done","not done")