| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Modified Date Formula for Pivot Tables
I'm trying to build a Pivot Table based on results scattered across a variety
of dates. I would like to find a formula that would modify the dates to the first of whatever month it took place in so the Pivot Table will chart all jobs in one month as one, rather than separate per indivdiual dates. Does anyone know of any formula I can use to create a modifed date? Ex. January 26, 2009 to 1/1/09 Tanelle |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot Tables - Date Filters | Excel Discussion (Misc queries) | |||
| Formula that displays the documents modified date | Excel Worksheet Functions | |||
| Formula for file modified date | Excel Discussion (Misc queries) | |||
| pivot tables by date range | Excel Discussion (Misc queries) | |||
| Using Date Grouping in Pivot Tables | Excel Discussion (Misc queries) | |||
Threaded Mode
