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]

[TABLE="width: 938"]
<colgroup><col span="2"><col span="2"><col><col><col><col><col></colgroup><tbody>[TR]
[TD]joined[/TD]
[TD]tenure days[/TD]
[TD]years[/TD]
[TD]remdays[/TD]
[TD]remmonths[/TD]
[TD]remdays[/TD]
[TD]stated in plain english[/TD]
[TD]today=[/TD]
[TD]27/06/2017[/TD]
[/TR]
[TR]
[TD]03/02/2008[/TD]
[TD]3432.00[/TD]
[TD]9[/TD]
[TD]144.75[/TD]
[TD]4[/TD]
[TD]23[/TD]
[TD]9 years 4 months 23 days[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]04/09/2013[/TD]
[TD]1392.00[/TD]
[TD]3[/TD]
[TD]296.25[/TD]
[TD]9[/TD]
[TD]22[/TD]
[TD]3 years 9 months 22 days[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
</tbody>[/TABLE]

 

[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.