I Have 1 Column where there dates are not Uniform.
I am using as a ref to derive one Column.

the date in column is

17/09/2010 i am changing the this format to 09/17/2010 by using =MID(H3,4,3)& MID(H3,1,3)&MID(H3,7,4).

But there are some dates Which are like 9/3/2007 now i want a formula to match all the dates.

Please Help me in this.