Issue with UK & USA Date Format

[Chris2020]

Is there a formula that I could use to convert US dates to UK dates. To explain a bit further , I have date in cells some with US dates and some with UK dates. What I would like to do is to leave the UK dates as they are and have the UK dates converted. Otherwise I would end up with a blanket formula that changes US to UK which is fine but inadvertently changes UK to US..

If there a formula that I cold use to achieve this?

 

[Fluff]

Hi & welcome to MrExcel.
Are you sure that some of the dates are UK dates?
It's unusual to have dates in both formats, but if you open a file with US dates, some (like 01/04/2020) will be recognised as dates but will be the wrong date, so you will have 1st Apr, rather than 4th Jan.