ExcelBanter - Date and Time

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Date and Time (https://www.excelbanter.com/excel-programming/404564-date-time.html)

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

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