Macro to convert dates to dd/mm/yyyy

[howard]

i receive a statement each month for eg 2021.05.25 and need a macro to convert these to date format dd/mm/yyyy

Account statement.XLS
	B
20	2021.04.17
21	2021.04.17
22	2021.05.27
23	2021.05.27
24	2021.05.27
25	2021.05.27
26	2021.05.27
27	2021.05.27
Sheet1

it would be appreciated if someone could assist me

 

[Dermot]

formula for B2
=DATE(LEFT(B2,4),MID(B2,6,2),RIGHT(B2,2))

 

[howard]

Many thanks for the help Dermot

 

[Joe4]

Another option that may work, depending upon regional settings:

=DATEVALUE(SUBSTITUTE(B20,".","/"))