Hello!
I have below sample table, and what I need is to group service date based on criteria tenure, is there any suggestion for a good formula?
I have below sample table, and what I need is to group service date based on criteria tenure, is there any suggestion for a good formula?
Book16 | ||||||
---|---|---|---|---|---|---|
A | B | C | D | |||
1 | Continuous Service Date | Tenure Group | Tenure Groups Criteria | |||
2 | 11/7/2016 | <2 years | ||||
3 | 1/30/2017 | 2-6 | ||||
4 | 10/15/2016 | 6-10 | ||||
5 | 10/24/2016 | 10-15 | ||||
6 | 12/1/2016 | 15+ | ||||
7 | 11/3/2016 | |||||
8 | 10/3/2016 | |||||
9 | 11/3/2016 | |||||
10 | 5/1/2019 | |||||
11 | 12/1/2016 | |||||
12 | 10/15/2016 | |||||
13 | 11/14/2016 | |||||
14 | 11/7/2016 | |||||
15 | 11/14/2016 | |||||
16 | 11/7/2016 | |||||
17 | 12/5/2016 | |||||
18 | 1/1/2017 | |||||
19 | 3/1/2017 | |||||
20 | 3/6/2017 | |||||
21 | 3/6/2017 | |||||
22 | 3/21/2017 | |||||
23 | 3/6/2017 | |||||
24 | 3/20/2017 | |||||
25 | 3/15/2017 | |||||
26 | 3/15/2017 | |||||
27 | 1/2/2017 | |||||
28 | 11/7/2016 | |||||
29 | 4/6/2015 | |||||
30 | 1/21/1995 | |||||
31 | 10/29/1994 | |||||
32 | 11/22/1993 | |||||
33 | 6/13/1994 | |||||
34 | 7/25/2012 | |||||
35 | 9/5/1995 | |||||
36 | 11/13/2006 | |||||
37 | 5/8/1996 | |||||
38 | 6/9/1997 | |||||
39 | 1/24/1998 | |||||
40 | 1/30/2017 | |||||
41 | 1/11/1999 | |||||
42 | 10/19/2020 | |||||
43 | 7/20/2010 | |||||
44 | 7/6/2009 | |||||
45 | 7/15/2001 | |||||
46 | 10/29/2013 | |||||
47 | 9/25/2000 | |||||
48 | 12/11/2002 | |||||
49 | 5/3/2010 | |||||
50 | 6/17/2002 | |||||
51 | 6/16/2003 | |||||
Sheet1 |