Hi, If I have a Date in Column O I want it to return a Yes if there is no date in Column O I want it to return a No- what's the best IF formula to use please, Thanks for your help.
I tried this one =IF(ISNUMBER(O4),"YES", IF(O4="","","NO")) but it returned all Yes
I tried this one =IF(ISNUMBER(O4),"YES", IF(O4="","","NO")) but it returned all Yes