Easiest to do it with a formula in the spreadsheet i a new column then copy
and paste special values only in the original column.

The use this forlula to convert date time to justt date

=DATE(YEAR(A1),MONTH(A1),DAY(A1))



"Aaron" wrote:

I have a report that I download from a DB and it has a range in column A that
is the date and time(1/16/2008 1:36:08 PM). I need a macro that will strip
this down to just the date so I can complete so formulas like Days360 between
another date. Can you help?

Thanks, Aaron