| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Date and Time
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Date and Time
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Converting text format of time/date into Excel time/date for subtr | Excel Worksheet Functions | |||
| Calculating days & time left from start date/time to end date/time | Excel Worksheet Functions | |||
| Combined date time cell to separate date & time components | Excel Discussion (Misc queries) | |||
| Combined date time cell to separate date & time components | Excel Discussion (Misc queries) | |||
| Combined date time cell to separate date & time components | Excel Discussion (Misc queries) | |||
Linear Mode
