Date Conversion Formula

Hi Guys,
So I am using a formula to convert a date cell from: "mm/dd/yyyy" to "dd/mm/yyyy" with:

=IF(ISTEXT(C7),DATE(RIGHT(C7,4),LEFT(C7,SEARCH("/",C7)-1),MID(C7,SEARCH("/",C7)+1,2)),DATEVALUE(TEXT(C7,"mm/dd/yyyy")))

But I can't seem to figure out why it is turning date: 6/31/2017 into 01/07/2017, the result i want should be 31/6/2017.

What do I need to tweak this??

Thanks!

Perhaps because the date is invalid: there are only 30 days in June so June 31st=1 st July

Jeez, that's embarrassing. Thanks Topley