| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Display dates as months
On Thu, 19 Apr 2007 19:24:03 -0700, KK wrote:
Hi, I have a range of dates such as: 3/19/2003 3/20/2003 3/20/2003 3/20/2003 3/21/2003 3/21/2003 3/21/2003 I need this to be converted in the Mar-03 format and do away with the individual dates so that I can use it for a pivot table. The above is only an example as I have 40,000 entries as above all various months. Would not Grouping by months in the Pivot table (or Months and Years) accomplish the same result more easily? --ron |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Display Months by looking at the dates | Excel Worksheet Functions | |||
| I want to display months and years on x axis | Charts and Charting in Excel | |||
| Adding months to dates should account for 28-30-31 day months | Excel Worksheet Functions | |||
| I want to subtract 2 dates and display the result as months | Excel Worksheet Functions | |||
| How do I display months and years between two dates | Excel Discussion (Misc queries) | |||
Threaded Mode
