Forum Discussion

Copper Contributor

Jul 12, 2023

Unable to change the date format

Hi, Can anyone please support me in changing the desired date format from Jul 9, 2023 22:59:16 +04 to dd/mm/yy Options I tried - 1. Custom date format (it's not reflecting in the cell value) 2...

excel

Formulas and Functions

SergeiBaklan

Diamond Contributor

Jul 12, 2023

chanchal20

As variant

=DATE(
    MID(A1, SEARCH(",", A1) + 2, 4),
    MONTH(LEFT(A1, SEARCH(",", A1) - 1)),
    DAY(LEFT(A1, SEARCH(",", A1) - 1))
)