Hi Kauflton!

Add a helper column with the following as the basis formula:

=TEXT(A1,"mmddyyyy")

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia

Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.