tenure calculation

  1. M

    Calculate Tenure with Several Variables

    I am trying to create a formula that answers the following question: What is the Tenure at the end of 2018 (12/31/2018) for a person that has a HIRED DATE before 12/31/2018 and has a TERMINATION DATE that is either within or after 2018. I really appreciate the help, I just cant get the...
  2. M

    Calculate Tenure with a Twist

    So I have two sheets. One sheet has my employee list with historic Start and End Dates. My other sheet is the summary of that list by Month. For example, lets say I have 10 Employees on my Employee sheet that all have Start and End dates, on my second sheet I have to summarize that info by...
  3. T

    Help on formula

    Need help on what formula to use to calculate the tenure of an employee from hire date in one cell and have that cell tenure count change once I put the resignation date of the employee in another cell
  4. S

    Calculate Tenure of an employee in the orgnanisation

    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.

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?

Disable AdBlock

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
Back
Top