A | B | C | D | E | F | G | H | I | |
---|---|---|---|---|---|---|---|---|---|
1 | Month | Day | Date | Month | Actual Date | Date | Month | AliGW | |
2 | 05 | 05/07/2019 | 05 | July | 07/05/2019 | 07 | May | 05/07/2019 | |
3 | 05 | 15/05/2019 | 15 | May | 15/05/2019 | 15 | May | 15/05/2019 | |
4 | 05 | 17/05/2019 | 17 | May | 17/05/2019 | 17 | May | 17/05/2019 | |
5 | 05 | 22/05/2019 | 22 | May | 22/05/2019 | 22 | May | 22/05/2019 | |
6 | 05 | 31/05/2019 | 31 | May | 31/05/2019 | 31 | May | 31/05/2019 | |
7 | 06 | 25/06/2019 | 25 | Jun | 25/06/2019 | 25 | June | 25/06/2019 | |
8 | 06 | 27/06/2019 | 27 | Jun | 27/06/2019 | 27 | June | 27/06/2019 | |
9 | 06 | 06/03/2019 | 06 | Mar | 03/06/2019 | 03 | June | 06/03/2019 | |
10 | 06 | 13/06/2019 | 13 | Jun | 13/06/2019 | 13 | June | 13/06/2019 | |
11 | 06 | 26/06/2019 | 26 | Jun | 26/06/2019 | 26 | June | 26/06/2019 | |
12 | 07 | 07/01/2019 | 07 | Jan | 01/07/2019 | 01 | July | 07/01/2019 | |
13 | 07 | 07/08/2019 | 07 | Aug | 08/07/2019 | 08 | July | 07/08/2019 | |
14 | 07 | 19/07/2019 | 19 | Jul | 19/07/2019 | 19 | July | 19/07/2019 | |
15 | 07 | 22/07/2019 | 22 | Jul | 22/07/2019 | 22 | July | 22/07/2019 |
Sheet: Text |
=--B2
didn't work ( and I didn't notice any changes in Your sent snapshot ).