hi All


I have a sheet with 2 different date formats
5/29/2009 9:00:02 AM
29/05/2009 09:00:01

is it possible to create a formula that will remove the time stamp and change all dates to dd/mm/yyyy?

I got as far as 
=MONTH(I2)&"/"&DAY(I2)&"/"&YEAR(I2)
this works for type 1 but returns an error for type 2, I tried switching the DAY and MONTH in the formula but am still getting the error

Thanks all

Noel