I'd like to be able to group employees that have left the company into "tenure groups" based on the length of time they were with the company.
The below table is an example of my dataset. The "tenure groups" are "0-6 months", "6-12 months", "1-5 years", and "5 years+". If an employee's end date is blank, that means they are still with the company (so perhaps a TODAY function would be inserted to calculate length of service). Thank you.
The below table is an example of my dataset. The "tenure groups" are "0-6 months", "6-12 months", "1-5 years", and "5 years+". If an employee's end date is blank, that means they are still with the company (so perhaps a TODAY function would be inserted to calculate length of service). Thank you.
Employee ID | Start Date | End Date | Tenure Group |
Emp2 | 01/12/2019 | 31/12/2021 | |
Emp3 | 24/07/2016 | 01/11/2016 | |
Emp4 | 11/04/2010 | 01/12/2019 | |
Emp5 | 30/09/2021 | ||
Emp6 | 17/01/2022 |