Hello,
I have in cell A2 Date in format 18-Nov-2020 UTC
I Need format 18.11.2020 in cell B2
I created this formula, but it probably won't be the right way:
=(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A3,"Nov","11"),"-",".")," UTC",""))
Dates change, so Jan = 1, Feb = 2, Mar = 3, Apr = 4, May = 5, Jun = 6, Jul = 7, Aug = 8, Sep = 9, Oct = 10, Nov = 11, Dec = 12
Please help my people
I have in cell A2 Date in format 18-Nov-2020 UTC
I Need format 18.11.2020 in cell B2
I created this formula, but it probably won't be the right way:
=(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A3,"Nov","11"),"-",".")," UTC",""))
Dates change, so Jan = 1, Feb = 2, Mar = 3, Apr = 4, May = 5, Jun = 6, Jul = 7, Aug = 8, Sep = 9, Oct = 10, Nov = 11, Dec = 12
Please help my people
