convert date from text (June 30, 2019) to UK format (dd/mm/yyyy)

[TwinkleW]

Hello, I'm trying to convert dates in this format: June 30, 2019, to UK date format: dd/mm/yyyy.
Can't see anything exactly like this in the forums.
Help! Thanks

Book1
	A	B	C
1	Date
2	June 30, 2019
3	July 31, 2019
4	August 31, 2019
5	September 30, 2019
6	October 31, 2019
7	November 30, 2019
8	December 31, 2019
9	January 31, 2020
10	February 29, 2020
11	March 31, 2020
Sheet1

 

[FormR]

Hi, are your dates always the last day of the month?

If so, you could try..

Book1
	A	B
1	Date
2	June 30, 2019	30/06/2019
3	July 31, 2019	31/07/2019
4	August 31, 2019	31/08/2019
5	September 30, 2019	30/09/2019
6	October 31, 2019	31/10/2019
7	November 30, 2019	30/11/2019
8	December 31, 2019	31/12/2019
9	January 31, 2020	31/01/2020
10	February 29, 2020	29/02/2020
11	March 31, 2020	31/03/2020
Sheet1

Cell Formulas
Range	Formula
B2:B11	B2	=EOMONTH(LEFT(A2,FIND(" ",A2))&RIGHT(A2,4),0)

 

[TwinkleW]

Hi, are your dates always the last day of the month?

If so, you could try..

Book1
	A	B
1	Date
2	June 30, 2019	30/06/2019
3	July 31, 2019	31/07/2019
4	August 31, 2019	31/08/2019
5	September 30, 2019	30/09/2019
6	October 31, 2019	31/10/2019
7	November 30, 2019	30/11/2019
8	December 31, 2019	31/12/2019
9	January 31, 2020	31/01/2020
10	February 29, 2020	29/02/2020
11	March 31, 2020	31/03/2020
Sheet1

Cell Formulas
Range	Formula
B2:B11	B2	=EOMONTH(LEFT(A2,FIND(" ",A2))&RIGHT(A2,4),0)

Yes, and that works! thank you