Headcount vs. FTE with dynamic arrays
One formula block that returns headcount, FTE and part-time share per month, per org unit — without a single helper column.
Excel (advanced)03 Headcount and FTEAdvanced18 min
The recording for this walkthrough is being published — the files below already contain the full model.
What you will build
- 01Build a month spine with SEQUENCE and EOMONTH
- 02Count active employees on a reference date with BYCOL and LET
- 03Reconcile FTE against the payroll total so the numbers survive an audit
Dataset used
2,400 anonymised employment records with entry date, exit date and contractual hours.