How to calculate Average Employee Tenure in Google Sheets?

Google Sheets - tutorial on how to calculate average employee tenure using formulas in Google Sheets.
Visit indzara.com/ for templates and tutorials.
Functions used: DATEDIF, INT, ROUND, AVERAGEIF, TODAY
how to calculate HR metrics
#hranalytics #hranalysis #hrmetrics #hrkpis #excel #peopleanalytics
Tenure is the time from Employee’s Start date to Today.
Average Employee Tenure is the average of all active employees in a company.
1. Let’s first calculate tenure for each employee.
Since we want to do this calculation for each employee, we should store the today’s date value once and re-use, instead of calculating TODAY for each employee.
2. Then we can calculate the average tenure for all active employees.