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"), " days")
Then I read that Microsoft has this function unofficial and doesn't recommend the "md" argument as it is buggy sometimes.
I experimented with a lot of dates and the formula was always successful.
Do you have any suggestions on this argument, or have something alternative?
Thank you in advance.
I came up with the following implementation:
=CONCATENATE(DATEDIF(B3,B4,"y")," years, ", DATEDIF(B3,B4, "ym"), " months and ", DATEDIF(B3,B4, "md"), " days")
Then I read that Microsoft has this function unofficial and doesn't recommend the "md" argument as it is buggy sometimes.
I experimented with a lot of dates and the formula was always successful.
Do you have any suggestions on this argument, or have something alternative?
Thank you in advance.