I was asked for an Excel solution that will refer the difference between hire date and today in the format: "9 years, 5 months and 2 days".
I came up with the following implementation:
=CONCATENATE(DATEDIF(B3,B4,"y")," years, ", DATEDIF(B3,B4, "ym"), " months and ", DATEDIF(B3,B4, "md"), "...