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?
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 | 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)) |
