Calculate Tenure of an employee in the orgnanisation

[sssanmeet]

Hi,

I need to calculate the tenure of employees in my org, i wrote this code however I keep getting an #value error, can someone help me?

=DATEDIF(C2,TODAY(),"y") & " years, " & DATEDIF(C2,TODAY(),"ym") & " months "

C2 is the cell where I have the employees joining date.

 

[oldbrewer]

joined	tenure days	years	remdays	remmonths	remdays	stated in plain english	today=	27/06/2017
03/02/2008	3432.00	9	144.75	4	23	9 years 4 months 23 days
04/09/2013	1392.00	3	296.25	9	22	3 years 9 months 22 days

<colgroup><col span="2"><col span="2"><col><col><col><col><col></colgroup><tbody>
</tbody>

 

[Logit]

.

=DATEDIF(C2,TODAY(),"y")&" years, "& DATEDIF(C2,TODAY(),"ym") &" month(s), "& DATEDIF(C2,TODAY(),"md")&" Days"

 

[sssanmeet]

.

=DATEDIF(C2,TODAY(),"y")&" years, "& DATEDIF(C2,TODAY(),"ym") &" month(s), "& DATEDIF(C2,TODAY(),"md")&" Days"

Hi Logit, Thanks a million it worked perfect as needed.

 

[Logit]

You are welcome. Glad to help.