Indzara - Simple and Effective Templates | How to calculate Average Employee Tenure in Google Sheets? @indzara | Uploaded 11 months ago | Updated October 03 2023
Google Sheets - tutorial on how to calculate average employee tenure using formulas in Google Sheets.

Visit https://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.