On Thu, 18 Jan 2018 17:52:08 +0000, jshaner69
wrote:


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"))

In Excel for Windoze, a cell formatted as type=date and blank will
have a date of ZERO. That is 1/1/1900.

Suggest your expression includes a test for I9=0.