Hi All,
please assist on the below.
Input Date:
i want to replace short name of month to number " JN/18/24 to 01/18/24, so that i can convert into proper format like MM/DD/YYYY or YYYY/MM/DD
| Date |
| JN/18/24 |
| FB/28/24 |
| MY/16/24 |
| JN/19/24 |
| AG/31/21 |
| MR/05/24 |
| NV/01/23 |
| JN/20/24 |
| JN/14/24 |
| JN/21/24 |
| MR/06/17 |
| FB/21/22 |
| MR/28/23 |
| MR/20/24 |
| MY/29/24 |
| MR/11/24 |
| JN/17/24 |
| SP/15/23 |
| MY/17/23 |
| JN/05/24 |
| MY/31/23 |
| JN/20/23 |
| MY/30/24 |
| DC/20/23 |
| DC/21/23 |
| OC/04/23 |
| AP/26/24 |
| NV/29/22 |
| JN/12/24 |
| MY/23/24 |
| MY/24/24 |
| FB/27/24 |
| JN/06/24 |
| OC/25/19 |
| Date_Short Name | Date |
| JA | 01 |
| FB | 02 |
| MR | 03 |
| AP | 04 |
| MY | 05 |
| JN | 06 |
| JL | 07 |
| AG | 08 |
| SP | 09 |
| OC | 10 |
| NV | 11 |
| DC | 12 |
