Assuming the dates in column A, one way:


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

In article ,
"Mohamed" wrote:

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