Unable to change the date format

chanchal20 

It seems like you are trying to change the date format from Jul 9, 2023 22:59:16 +04 to dd/mm/yy in Excel. Here are some possible solutions that

- You can use the **TEXT** function to convert the date to a text string in the desired format. For example, if the date is in cell A1, you can use this formula in another cell: =TEXT(A1,"dd/mm/yy"). This will display the date as 09/07/23. However, this will not change the underlying value of the date, which is a serial number in Excel.
- You can use the **DATEVALUE** function to convert the date to a serial number that Excel can recognize as a date. For example, if the date is in cell A1, you can use this formula in another cell: =DATEVALUE(A1). This will return the serial number 44575, which corresponds to July 9, 2023. You can then apply any date format you want to this cell by using the Format Cells dialog box or the Number group on the Home tab.

- You can use the **LET** and **TEXTSPLIT** functions to parse the date into its components and then use the **DATE** function to create a new date value. For example, if the date is in cell A1, you can use this formula in another cell: =LET(a,TEXTSPLIT(A1," "),DATE(RIGHT(INDEX(a,3),2),MONTH(DATEVALUE(INDEX(a,1)&" 1")),INDEX(a,2))). This will return the serial number 44575, which corresponds to July 9, 2023. You can then apply any date format you want to this cell by using the Format Cells dialog box or the Number group on the Home tab