| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I convert a date&time (yyyy-mm-dd hh:mm:ss) to date only?
Wesley,
With the date in A1: =INT(A1) formatted for date. HTH, Bernie MS Excel MVP "Wesley Accellent" <Wesley wrote in message ... I am trying to convert a date & time into a date only so I can get a pivot table to do a daily summary. Is there a function that can convert? Is there another way to do a daily summary with a pivot table? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I convert a date&time (yyyy-mm-dd hh:mm:ss) to date onl
It hurts my feelings that it is that easy, but it works great.
Just what I needed. Thanks, Wesley "Bernie Deitrick" wrote: Wesley, With the date in A1: =INT(A1) formatted for date. HTH, Bernie MS Excel MVP "Wesley Accellent" <Wesley wrote in message ... I am trying to convert a date & time into a date only so I can get a pivot table to do a daily summary. Is there a function that can convert? Is there another way to do a daily summary with a pivot table? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I create a schedule from a list of dates ? | Charts and Charting in Excel | |||
| How do I convert a list of date of births into age in Excel? | Excel Worksheet Functions | |||
| How do I convert Date serial number to date | Excel Worksheet Functions | |||
| convert julian date to gregorian date | Excel Discussion (Misc queries) | |||
| How do I convert a Julian date into a regular date? | Excel Discussion (Misc queries) | |||
Hybrid Mode
