Forum Discussion
Weekly Headcount from Start/Stop Dates
| Emp # | Start Date | End Date | Status |
| 1 | 2/5/22 | 6/5/22 | Active |
| 1 | 6/5/22 | 7/15/22 | Active |
| 1 | 7/15/22 | 12/30/22 | Active |
| 2 | 7/24/22 | 11/14/22 | Active |
| 2 | 11/14/22 | 2/5/23 | Active |
| 2 | 2/5/23 | 7/13/23 | Active |
| 3 | 6/3/23 | 7/13/23 | Active |
Example of my data above.
I want to find a weekly active headcount so I can find the average of the year by taking the weekly counts. So I want to look at any weekending and know how many employees were active on that date. But my employee data is structered with these start and stop dates, not weekly. How do you suggest is the best way for me to get these weekly active headcounts weekly from the current data? I am a bit stuck...
