Swap characters from middle of date to beginning

[jlarmen]

Hello, I did a search and could not find a specific help for this. Jotform outputs my Excel so the dates are D/M/Y and I needed it M/D/Y. I formatted the column as date with the correct format, but the dates don't change.

master.xlsx
	C	D
1	Gender	Child's Birthday
2	Female	22-06-2015
3	Female	25-03-2008
4	Female	25-03-2008
5	Male	06-07-2010
6	Female	23-07-2008
7	Male	04-12-2007
Sheet1

I was trying to figure out how to move the M to the beginning using a formula. Any suggestions?

 

[Fluff]

Select col D & on the data tab, select Text to columns, delimited, next, uncheck all boxes, next, select DMY from the date drop down, Finish.

 

[jlarmen]

Select col D & on the data tab, select Text to columns, delimited, next, uncheck all boxes, next, select DMY from the date drop down, Finish.

So this happened. It only worked for some, yet the formation on all of the is date.

master.xlsx
	D
1	Child's Birthday
2	22-06-2015
3	25-03-2008
4	25-03-2008
5	6/7/10
6	23-07-2008
7	4/12/07
8	19-11-2009
9	22-04-2017
10	30-06-2009
11	1/9/15
12	23-10-2010
13	3/6/11
14	3/3/11
15	30-03-2012
16	20-07-2009
17	22-06-2012
18	5/1/11
19	7/7/08
20	20-02-2012
21	27-10-2013
22	31-08-2016
23	19-12-2009
24	21-02-2014
25	10/10/13
26	15-06-2011
27	25-08-2014
28	27-07-2011
29	12/6/09
30	11/11/12
31	18-12-2012
32	11/12/09
33	6/1/14
34	6/3/13
35	30-01-2014
36	24-06-2015
37	15-12-2010
38	30-09-2009
39	30-04-2008
40	8/3/10
41	22-01-2013
42	19-12-2007
43	29-11-2015
44	27-07-2010
45	3/2/09
46	3/1/11
47	3/1/11
48	22-06-2015
49	10/2/08
50	20-06-2011
51	21-09-2008
52	13-11-201
53	10/12/07
54	21-11-2013
55	7/9/11
56	28-10-2021
57	31-01-2012
58	9/10/10
59	25-03-2008
60	22-09-2009
61	1/8/09
62	7/5/10
63	16-03-2010
64	2/7/08
65	20-04-2012
66	1/6/09
67	22-11-2013
68	31-03-2008
69	29-10-2010
70	9/6/14
71	4/8/11
72	3/5/07
73	13-11-2012
74	3/6/16
75	22-06-2015
76	30-10-2021
77	26-08-2013
78	14-06-2008
79	13-01-2014
80	20-10-2015
81	11/2/11
82	4/2/13
83	30-04-2014
84	19-11-2012
85	1/8/13
86	30-04-2012
87	22-11-2013
88	30-03-2012
89	23-11-2007
90	3/6/11
91	13-02-2013
92	25-10-2009
93	7/7/16
94	3/3/14
95	18-01-2013
96	21-07-2017
Sheet1

 

[jlarmen]

I figured out a workaround. Using the text to columns, I separated them using the "-" then concatenated them into another column in correct order using =CONCATENATE(F2,"/",E2,"/",G2).

 

[Fluff]

Glad you sorted it & thanks for the feedback.