Macros to find the dates in a column and replace with a different format. Excel 2003

I need a macros to replace the dates in Column C which is in the format (MM/DD/YY HH:MM AM/PM) to the format (MM/DD/YYYY).
Basically I want to replace the contents of Column C with just the date excluding the time.
And I want this to be done dynamically, if more rowas are added or removed it sgould do it automatically.
I have attached an example file with the raw data.