Tenure & Age Bands with DATEDIF and COUNTIFS
This lesson is part of the course
In this lesson
You calculate tenure and age in completed years and count employees per band for the year-end report.
Buy the course once for $9.99 to unlock every lesson and lab, the final exam and the certificate – lifetime access, no subscription.
Lessons in this course
- Headcount & FTE with Part-Time Staff Locked
- Turnover & Retention Rates Locked
- Tenure & Age Bands with DATEDIF and COUNTIFS Locked
- Compensation: Compa-Ratio, Salary Bands & Median Pay Locked
- Gross-to-Net Payroll & Employer Cost Locked
- Recruiting Funnel: Time-to-Hire, Cost-per-Hire & Offer Acceptance Locked
- Absence & Overtime KPIs: Bradford Factor and Overtime Cost Locked