# Calculate Tenure of an employee in the orgnanisation

#### sssanmeet

##### New Member
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.

### Excel Facts

Format cells as currency
Select range and press Ctrl+Shift+4 to format cells as currency. (Shift 4 is the \$ sign).

#### oldbrewer

##### Well-known Member
 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

##### Well-known Member
.
Code:
``=DATEDIF(C2,TODAY(),"y")&" years, "& DATEDIF(C2,TODAY(),"ym") &" month(s), "& DATEDIF(C2,TODAY(),"md")&" Days"``

#### sssanmeet

##### New Member
.
Code:
``=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

##### Well-known Member
You are welcome. Glad to help.

Replies
2
Views
226
Replies
3
Views
72
Replies
5
Views
307
Replies
2
Views
495
Replies
3
Views
160

1,186,986
Messages
5,960,964
Members
438,504
Latest member
KristofGoossens

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

### Which adblocker are you using?

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

### Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back