Employee Head Count Pivot Table

[goob90]

I am trying to create a pivot table that has a headcount of employees broken down by year and qtr. I am working on a dashboard and would like to include data from previous years (2016-current).

I have created a table with sample data that includes fictional names, hire date, termination date, and current status. This is the same format that I am using in my dashboard.

Dashboard.xlsx
	A	B	C	D
1	Employee Name	Hire Date	Termination Date	Status
2	Brooklyn Orn	1/1/1999	12/31/2016	Terminated
3	Cassandre Koss	7/1/2008	2/28/2022	Terminated
4	Curtis Gerhold	10/8/2012	12/26/2018	Terminated
5	Burley Heidenreich	10/13/2003		Active
6	Jett Murray	11/17/2003		Active
7	Kay Stracke IV	2/25/2002	9/13/2019	Terminated
8	Citlalli Cummerata	6/9/2014	3/13/2019	Terminated
9	Deven Kessler	8/29/2014	3/13/2019	Terminated
10	Vena Hettinger III	8/29/2014	1/25/2019	Terminated
11	Milo Ledner	2/7/2016		Active
12	Norval Lueilwitz	5/9/2016		Active
13	Angie Ledner	4/3/2017	5/2/2019	Terminated
14	Katharina D'Amore	2/5/2018		Active
15	Luna Oberbrunner	3/20/2019	6/30/2022	Terminated
16	Henriette Kilback	4/8/2019	11/4/2019	Terminated
17	Baby Medhurst IV	7/29/2019	3/20/2020	Terminated
18	Marisol Von	9/3/2019		Active
19	Augustine Haley	11/8/2019		Active
20	Bradley Schoen	12/22/2019	6/30/2022	Terminated
21	Misael Zulauf	9/14/2020	1/1/2022	Terminated
22	Andre Hane	12/14/2020		Active
23	Andrew Hills	4/13/2021		Active
24	Nathen Terry	5/24/2021	5/26/2021	Terminated
25	Shawna Stark	6/15/2021		Active
26	Everett Welch	6/13/2022		Active
27	Adolfo Schroeder	7/4/2022		Active
28	Velda Jaskolski	7/11/2022		Active
29	Dr. Ida Abernathy	8/12/1996		Active
30	Brody Hand PhD	1/30/2017		Active
31	Keith Barton	11/28/2005		Active
32	Dolores Price	3/24/2014		Active
33	Kraig Johns	9/15/2008	3/15/2016	Terminated
34	Felicita Langworth DVM	6/17/2002	5/11/2017	Terminated
35	Lionel Fahey	10/13/2014		Active
36	Wilhelm Rice	6/13/2016	7/27/2018	Terminated
37	Lauryn Bogisich	6/13/2016	2/14/2022	Terminated
38	Camille Yost	1/30/2017	4/11/2022	Terminated
39	Lionel Beer IV	5/22/2017	3/4/2019	Terminated
40	Kyla Hermiston	1/2/2019		Active
41	Margaretta Kshlerin	1/2/2019	9/3/2021	Terminated
42	Ms. Kylie Daniel	3/11/2019		Active
43	Miss Ardella Kling	3/2/2020		Active
44	Hilma Nicolas	11/30/2020		Active
45	Sim Kunde	2/14/2022		Active
46	Mrs. Jettie Bruen	3/7/2022		Active
47	Connie Gottlieb	6/28/2021		Active
48	Hoyt Beatty	9/1/2021		Active
49	Emmy DuBuque	9/15/2021		Active
50	Minnie Hoppe	1/24/2022		Active
51	Kaylie Hyatt Sr.	4/20/2009	7/31/2019	Terminated
52	Vivian Volkman IV	3/19/1990	3/20/2020	Terminated
53	Berenice Gusikowski	10/10/1995	1/8/2016	Terminated
54	Sylvan Renner	1/4/2016	4/28/2017	Terminated
55	Reva Ebert	1/11/2016	4/5/2018	Terminated
56	Teresa Lynch	3/13/2017		Active
57	Margret Howe	6/1/2017	8/27/2021	Terminated
58	Monte Padberg	5/27/2018		Active
59	Bertrand Lindgren	8/13/2001	8/13/2021	Terminated
Sheet1

Thanks!