Forum Discussion
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...
Let's say you have such a value in D2.
Enter the following formula in - for example - E2:
=DATEVALUE(MID(D2,FIND(" ",D2)+1,FIND(",",D2)-FIND(" ",D2)-1)&"-"&LEFT(D2,3)&"-"&MID(D2,FIND(",",D2)+2,4))
Format the cell with the formula as a date.
The formula can be filled or copied down.