Sample employee data Retention.xlsx

	A	B	C	D	E	F	G	H
1	Payroll #	Name	Team	Seniority	Start date	Departure date	TODAY	Tenure/days
2	1040	Hilary Blackford	Production	Manager	21/3/2018	5/7/2022	19/9/2026	1,567
3	2786	Rosemary Hussain	Design	Manager	28/12/2022	N/A	19/9/2026	1,361
4	5058	Alexander Fraser	Design	Manager	21/12/2018	N/A	19/9/2026	2,829
5	6147	Jonathan Ellard	Design	Entry level	4/4/2018	N/A	19/9/2026	3,090
6	7622	Cornelus Hofman	Design	Entry level	15/2/2021	N/A	19/9/2026	2,042
7	9376	Neil Edgley	Production	Director	2/3/2021	N/A	19/9/2026	2,027
8	3242	Mary Mitchell	Executive	Executive	2/5/2018	N/A	19/9/2026	3,062
9	5548	Simone Brown	Executive	Executive	26/9/2018	N/A	19/9/2026	2,915
10	8102	Mohammed Hussain	Executive	Executive	30/12/2021	N/A	19/9/2026	1,724
11	8821	Simon Moger	Executive	Executive	22/5/2019	N/A	19/9/2026	2,677
12	3888	Andrew McGowan	Finance	Entry level	19/6/2017	7/8/2020	19/9/2026	1,145
13	4068	Timothy Appleton	Finance	Manager	24/11/2017	N/A	19/9/2026	3,221
14	6650	William Dyer	Production	Entry level	18/7/2017	11/10/2021	19/9/2026	1,546
15	7547	Warren Dixon	Finance	Manager	10/2/2022	13/12/2022	19/9/2026	306
16	8195	Manjinder Bansal	Finance	Director	27/8/2018	10/6/2019	19/9/2026	287
17	8551	Michelle McCarthy	Finance	Entry level	6/6/2017	N/A	19/9/2026	3,392
18	9689	Mohit Mansukhani	Finance	Entry level	23/1/2017	12/2/2019	19/9/2026	750
19	9695	Beverly Daniels	Finance	Entry level	23/11/2021	N/A	19/9/2026	1,761
20	21346	Gabriel Ajayi	Finance	Entry level	28/6/2017	N/A	19/9/2026	3,370
21	3630	Richard Duncan	HR	Entry level	22/2/2021	2/4/2021	19/9/2026	39
22	5678	Tanya Patel	HR	Entry level	5/3/2018	3/4/2022	19/9/2026	1,490
23	8132	Timothy Parr	HR	Entry level	25/8/2020	N/A	19/9/2026	2,216
24	8192	Kevin Chapman	HR	Entry level	3/6/2021	1/2/2023	19/9/2026	608
25	8256	Gerson Barnett	HR	Director	20/8/2019	N/A	19/9/2026	2,587
26	8482	Clifford Groom	HR	Entry level	1/9/2020	N/A	19/9/2026	2,209
27	1199	Ivan Ezekiel	Production	Entry level	12/10/2018	1/3/2022	19/9/2026	1,236
28	1778	Adam Bromley	Production	Director	5/5/2020	30/8/2022	19/9/2026	847
29	1977	Wendy Batchelor	Production	Director	13/9/2017	11/4/2022	19/9/2026	1,671
30	2597	Clive Bean	Production	Manager	18/11/2019	N/A	19/9/2026	2,497
31	2633	Steven Godwin	Production	Entry level	24/8/2017	9/6/2020	19/9/2026	1,020
32	2739	Christopher Benton	Production	Entry level	4/12/2019	17/1/2020	19/9/2026	44
33	2981	Russell Cowan	Production	Manager	15/10/2020	N/A	19/9/2026	2,165
34	5304	Stella Ellis	Production	Entry level	8/2/2022	4/7/2022	19/9/2026	146
35	1161	Paul Chandler	Sales	Manager	19/9/2019	5/7/2022	19/9/2026	1,020
36	1234	John Smith	Sales	Director	1/3/2018	3/9/2023	19/9/2026	2,012
37	2388	Adham Mohammed	Sales	Entry level	12/2/2019	28/7/2020	19/9/2026	532
38	2678	Nurul Ahmed	Sales	Entry level	9/2/2016	27/9/2021	19/9/2026	2,057
39	2690	Harvey Dua	Sales	Entry level	24/6/2016	1/3/2022	19/9/2026	2,076
40	2891	Joseph Attwood	Sales	Manager	9/11/2016	25/7/2017	19/9/2026	258
41	3732	Simon Drury	Production	Entry level	9/8/2022	N/A	19/9/2026	1,502
42	4548	Catherine Butler	Sales	Entry level	2/1/2019	N/A	19/9/2026	2,817
43	4881	Steven Ball	Sales	Entry level	9/1/2017	N/A	19/9/2026	3,540
44	5286	David King	Sales	Manager	4/7/2016	N/A	19/9/2026	3,729
45	6763	Sarah Hill	Sales	Entry level	24/11/2020	N/A	19/9/2026	2,125
46	8491	Steve Leigh	Sales	Entry level	2/9/2016	N/A	19/9/2026	3,669
47	9352	Alexander Hunter	Sales	Entry level	1/11/2021	N/A	19/9/2026	1,783
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100