tracking # of employees quarter over quarter
I'm trying to show on a graph how many employees we had in each quarter. How would I do that?
My initial idea is to add a helper column for each quarter, and add a formula to return a 1 if any of the date range of that quarter falls after their start date and before their end date, then pull a report counting the 1s for each quarter.
That's already a problem because of rehires. Those may have to be fixed manually.
After this my brain grinds to a halt.
Has anyone successfully charted something like this?
Help Article Resources
Check out the Formula Handbook template!