What is the formula for changing date type?

Question

excel

Tell me the formula, or maybe somehow built-in functions, you can replace the date in Excel:
Nov 5, 1986 -> 11/05/1986
Dec 23, 1992 -> 12/23/1992
in the cell format, the date does not change at all ..

Answer 1

There is no such date format in Excel, so it does not convert them.
You can try this formula:

=СЦЕПИТЬ(ЕСЛИ(ДЛСТР(ПСТР(A1;ПОИСК(" ";A1)+1;ПОИСК(",";A1)-ПОИСК(" ";A1)-1))<2;СЦЕПИТЬ("0";ПСТР(A1;ПОИСК(" ";A1)+1;ПОИСК(",";A1)-ПОИСК(" ";A1)-1));ПСТР(A1;ПОИСК(" ";A1)+1;ПОИСК(",";A1)-ПОИСК(" ";A1)-1));".";ЕСЛИ(ЛЕВСИМВ(A1;ПОИСК(" ";A1;1)-1)="Jan";"01";ЕСЛИ(ЛЕВСИМВ(A1;ПОИСК(" ";A1;1)-1)="Feb";"02";ЕСЛИ(ЛЕВСИМВ(A1;ПОИСК(" ";A1;1)-1)="Mar";"03";ЕСЛИ(ЛЕВСИМВ(A1;ПОИСК(" ";A1;1)-1)="Apr";"04";ЕСЛИ(ЛЕВСИМВ(A1;ПОИСК(" ";A1;1)-1)="May";"05";ЕСЛИ(ЛЕВСИМВ(A1;ПОИСК(" ";A1;1)-1)="June";"06";ЕСЛИ(ЛЕВСИМВ(A1;ПОИСК(" ";A1;1)-1)="July";"07";ЕСЛИ(ЛЕВСИМВ(A1;ПОИСК(" ";A1;1)-1)="Aug";"08";ЕСЛИ(ЛЕВСИМВ(A1;ПОИСК(" ";A1;1)-1)="Sept";"09";ЕСЛИ(ЛЕВСИМВ(A1;ПОИСК(" ";A1;1)-1)="Oct";"10";ЕСЛИ(ЛЕВСИМВ(A1;ПОИСК(" ";A1;1)-1)="Nov";"11";ЕСЛИ(ЛЕВСИМВ(A1;ПОИСК(" ";A1;1)-1)="Dec";"12";"WTF"))))))))))));".";ПСТР(A1;ПОИСК(", ";A1)+2;ДЛСТР(A1)-ПОИСК(", ";A1)+2))