If cell is populated- return as "completed"

[VMARTINEZ939]

Please help with the IF function.
IF AY CELL IS POPULATE WITH DATE- ANY DATE.
RETURN DATA UNDER COLUMN S AS "COMPLETED"
IF AY CELL IS POPULATED I DO NOT NEED TO GO ANY FURTHER IN TRACKING THIS JOB.

---

 

[Roderick_E]

in column S, S2 presumably, use this code =if(isnumber(ay2),"COMPLETED","") Drag down formula.

 

[FDibbins]

if the cell will only contain a date...
=if(AY1="","","completed")

 

[VMARTINEZ939]

worked thank you