Hi please forgive my lack of experience I’m a newbie.
How can I have a blank cell if no data entered I’ve tried stuff I’ve found on the internet but no luck. Thanks
=IF(DATEDIF(C2, TODAY(),"y")=0,"",DATEDIF(C2, TODAY(),"y")&" years, ")& IF(DATEDIF(C2, TODAY(),"ym")=0,"",DATEDIF(C2, TODAY(),"ym")&" months, ")& IF(DATEDIF(C2, TODAY(),"md")=0,"",DATEDIF(C2, TODAY(),"md")&" days")
How can I have a blank cell if no data entered I’ve tried stuff I’ve found on the internet but no luck. Thanks
=IF(DATEDIF(C2, TODAY(),"y")=0,"",DATEDIF(C2, TODAY(),"y")&" years, ")& IF(DATEDIF(C2, TODAY(),"ym")=0,"",DATEDIF(C2, TODAY(),"ym")&" months, ")& IF(DATEDIF(C2, TODAY(),"md")=0,"",DATEDIF(C2, TODAY(),"md")&" days")