Attrition forecast for next 3 months?

[zinah]

Hi,

I have a report that has termination date and hiring date of employees and what I need to get is the attrition forecast of the coming 3 months. Is there any suggestions?

Attrition Forecast (3 months).xlsx
	A	B	C
1	Employee	Termination Date	Hire Date
2	A	6/3/2022	2/24/2020
3	B	5/30/2022	4/13/2020
4	C	5/16/2022	7/6/2020
5	D	5/6/2022	1/22/2018
6	E	5/6/2022	7/29/2019
7	F	5/3/2022	5/5/2014
8	G	4/29/2022	6/18/2018
9	H	4/27/2022	3/15/2021
10	I	4/14/2022	6/24/2019
11	J	4/8/2022	5/19/2021
12	K	4/1/2022	5/31/2016
13	L	3/25/2022	12/29/2014
14	M	3/25/2022	4/19/2021
15	N	3/11/2022	1/26/2015
16	O	3/11/2022	8/12/2020
17	P	3/11/2022	6/7/2021
18	Q	3/2/2022	3/1/2021
19	R	3/1/2022	11/20/2017
20	S	2/25/2022	5/20/2019
21	T	2/18/2022	3/18/2013
22	U	2/11/2022	9/22/2014
23	V	1/25/2022	4/8/2019
24	W	1/14/2022	4/2/2018
25	X	1/7/2022	10/22/2018
26	Y	1/4/2022	7/6/2015
27	Z	12/17/2021	4/19/2021
28	AA	11/26/2021	9/11/2017
29	BB	11/24/2021	4/1/2019
30	CC	11/12/2021	11/23/2020
31	DD	11/5/2021	6/9/2014
32	EE	11/5/2021	5/13/2019
33	FF	10/29/2021	10/29/2019
34	GG	10/29/2021	2/8/2021
35	HH	10/27/2021	4/1/2019
36	II	5/31/2022	4/1/2019
37	JJ	6/3/2022	11/14/2016
38	KK	5/2/2022	1/7/2019
39	LL	7/29/2022	7/15/2019
40	MM	5/13/2022	2/5/2018
41	NN	6/10/2022	9/11/2019
42	OO	5/17/2022	12/9/2019
43	PP	5/4/2022	12/2/2020
44	QQ	4/14/2022	12/18/2017
45	RR	5/17/2022	4/6/2020
46	SS	4/5/2022	2/15/2021
47	TT	4/30/2022	3/1/2018
48	UU	5/27/2022	9/11/2017
49	VV	4/29/2022	7/12/2021
50	WW	4/18/2022	1/9/2017
51	XX	4/15/2022	5/27/2019
52	YY	4/30/2022	9/1/2020
53	ZZ	4/1/2022	12/10/2021
54	AA[	4/29/2022	10/28/2019
55	BB\	2/18/2022	11/13/2018
56	CC]	5/4/2022	8/19/2019
57	DD^	5/4/2022	9/18/2017
58	EE_	5/6/2022	2/27/2019
59	FF`	4/1/2022	12/7/2020
60	GGa	3/18/2022	3/12/2012
61	HHb	3/18/2022	1/2/2006
62	IIc	3/31/2022	5/20/2019
63	JJd	4/15/2022	3/31/2014
64	KKe	4/8/2022	2/17/2020
65	LLf	3/11/2022	1/27/2022
66	MMg	3/11/2022	11/13/2018
67	NNh	4/7/2022	3/18/2019
68	OOi	3/31/2022	10/1/2018
69	PPj	4/1/2022	7/10/2017
70	QQk	3/31/2022	9/15/2008
71	RRl	4/7/2022	12/17/2018
72	SSm	3/17/2022	4/25/2019
73	TTn	3/25/2022	11/9/2020
74	UUo	3/14/2022	4/23/2018
75	VVp	2/21/2022	1/4/2022
76	WWq	4/4/2022	9/25/2019
77	XXr	3/11/2022	9/8/2014
78	YYs	4/8/2022	7/1/2021
79	ZZt	2/18/2022	4/5/2021
80	AA[u	3/11/2022	9/7/2021
81	BB\v	3/31/2022	12/1/2010
82	CC]w	2/18/2022	10/6/2005
83	DD^x	3/31/2022	9/2/2019
84	EE_y	3/25/2022	4/26/2021
85	FF`z	2/15/2022	9/12/2005
86	GGa{	2/4/2022	11/2/2020
87	HHb|	2/28/2022	7/1/2010
88	IIc}	1/28/2022	5/2/2017
89	JJd~	1/21/2022	7/11/2005
90	KKe	3/4/2022	9/14/2018
91	LLf€	1/21/2022	1/17/2017
92	MMg	1/13/2022	8/22/2016
93	NNh‚	1/13/2022	9/19/2016
94	OOiƒ	1/28/2022	3/14/2018
95	PPj„	1/7/2022	1/2/2013
96	QQk…	12/31/2021	7/9/2018
97	RRl†	1/25/2022	4/29/2019
98	SSm‡	1/21/2022	6/18/2018
99	TTnˆ	1/11/2022	9/19/2018
100	UUo‰	1/18/2022	9/4/2019
101	VVpŠ	1/7/2022	6/29/2015
102	WWq‹	1/5/2022	2/1/2021
103	XXrŒ	1/14/2022	1/11/2016
104	YYs	3/31/2022	12/9/1996
105	ZZtŽ	1/7/2022	3/9/2021
106	AA[u	1/7/2022	7/15/2019
107	BB\v	12/27/2021	11/4/2019
108	CC]w‘	12/27/2021	9/18/2019
109	DD^x’	12/10/2021	6/1/2018
110	EE_y“	1/28/2022	1/3/2011
111	FF`z”	1/24/2022	11/5/2007
112	GGa{•	12/27/2021	8/12/2019
113	HHb|–	1/7/2022	5/18/2015
114	IIc}—	12/30/2021	7/23/2018
115	JJd~˜	12/31/2021	8/1/2006
116	KKe™	12/15/2021	6/4/2012
117	LLf€š	12/10/2021	1/9/2017
118	MMg›	1/5/2022	1/6/2020
119	NNh‚œ	1/28/2022	6/5/2019
120	OOiƒ	12/25/2021	8/1/2016
121	PPj„ž	12/17/2021	1/11/2021
122	QQk…Ÿ	1/3/2022	4/2/2018
123	RRl†	11/30/2021	3/10/2016
124	SSm‡¡	12/15/2021	10/3/2018
125	TTnˆ¢	12/24/2021	7/23/2018
126	UUo‰£	12/17/2021	10/1/2018
127	VVpŠ¤	11/26/2021	5/2/2017
128	WWq‹¥	12/10/2021	8/1/2016
129	XXrŒ¦	11/25/2021	2/1/2013
130	YYs§	11/26/2021	11/19/2018
131	ZZtŽ¨	12/14/2021	4/12/2021
132	AA[u©	11/19/2021	1/4/2021
133	BB\vª	12/1/2021	10/26/2015
134	CC]w‘«	11/16/2021	12/15/2016
135	DD^x’¬	11/19/2021	9/25/2017
136	EE_y“	12/3/2021	8/19/2019
Sheet1

Cell Formulas
Range	Formula
A2:A27	A2	=CHAR(ROW(A65))
A28:A136	A28	=A2&CHAR(ROW(A65))