text to numbers again!

Enter formula in A1 and copy down

Formula:

Please Login or Register  to view this content.

Or this

Formula:

Please Login or Register  to view this content.

v	A	B
1	6/1/2017	Thu, 1 Jun
2	6/2/2017	Fri 2 Jun
3	6/3/2017	Sat 3 Jun
4	6/4/2017	Sun 4 Jun
5	6/5/2017	Mon 5 Jun
6	6/6/2017	Tue 6 Jun
7	6/7/2017	Wed 7 Jun
8	6/8/2017	Thu 8 Jun
9	6/9/2017	Fri 9 Jun
10	6/10/2017	Sat 10 Jun
11	6/11/2017	Sun 11 Jun
12	6/12/2017	Mon 12 Jun
13	6/13/2017	Tue 13 Jun
14	6/14/2017	Wed 14 Jun
15	6/15/2017	Thu 15 Jun
16	6/16/2017	Fri 16 Jun
17	6/17/2017	Sat 17 Jun
18	6/18/2017	Sun 18 Jun
19	6/19/2017	Mon 19 Jun
20	6/20/2017	Tue 20 Jun
21	6/21/2017	Wed 21 Jun
22	6/22/2017	Thu 22 Jun
23	6/23/2017	Fri 23 Jun
24	6/24/2017	Sat 24 Jun
25	6/25/2017	Sun 25 Jun
26	6/26/2017	Mon 26 Jun