Hiding an unintended value
if I9 does not have a date then J9 read "118 Years, 0 months, 18days and I want it to be blank. Any help would be greatly appreciated. I tried the basics but then just a FALSE reading.
J9 Formula: =IF(K9<"","Placed Out of Service",(DATEDIF(I9,NOW(),"y")&" years, "&DATEDIF(I9,NOW(),"ym")&" months, "&DATEDIF(I9,NOW(),"md")&" days"))
|