tenure

Hi, I'm trying to group dates under tenure grouping and some group members here helped with suggesting the formula I'm using in my below example, but I noticed the tenure category grouping has some issues as it's not choosing the right group when the months of service is greater than 5 years...

Hi I am trying to figure out a formula that would give me the average tenure per year of the Active employees for that year. I have a list of the employees with start and end dates and their Departments, and their tenure for each year they worked. Here are the two lists: What I need is to get...

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

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

I have a table in which i have tenure in months in column A from 1 month to 60 months. I have categorize months in 3 parts , (12 - 23) , (24-35) and (36 to 60) (12-23) is 8% (24-35) is 8.15% (36-60) is 8.75% I need to build a calculator with the help of macro that will calculate premium...

Good day I was trying to get a tenure using a specific value in array. The Formula I'm using works fine but I encounter issue when the criteria I was looking for has a duplicate in Row What I am trying to obtain is to get the tenure of an employee using the most recent data in a the array...

I am having troubles getting a payroll calculation formula set up. We have annual increases for employees (tenure) and I need to factor in different pay rates for different job types. Basic layout of Sheet 1 <tbody> A B C D E F 1 Employee Hours Tenure Type Income 2 AAA 3...

Hey Everyone, I'm trying to create a graph that tracks performance by tenure week. For example, there's a group of people who started work on, say, 4/1/2018, we'll call them Wave 1. Wave 2 started on 4/31/2018 and Wave 3 started on 5/5/2018. I want to be able to track a specific metric by...

I've looked at several index/match and index/indirect formulas here but I cannot wrap my head around this. I have all data on 1 sheet, but need to show the results from the formula on another sheet. Here is what I am working with: Sheet Analysts has all the data I need. Column A is AGENT ID...

Hi there trying to get some logic to work here. I have Jul-Oct YTD sales number of $824 for sales rep based on tenure in the company. Fiscal month = 4 Tenure in company in months (current year) = 4 I want to annualize it for full year, so will the calculation be: =($824/# months worked in...