+ Reply to Thread
Results 1 to 2 of 2

Pivot table week grouping date format

  1. #1
    Registered User
    Join Date
    12-12-2012
    Location
    USA
    MS-Off Ver
    Office365
    Posts
    32

    Pivot table week grouping date format

    Dear friends,
    Isn't there a way to format date field while grouping it into week.
    It shows all in number format as for eg. 05-08-13 - 11-08-13
    I want this as 05-Aug-13 - 11-Aug-13
    Appreciate your help on this.

    rgds,
    Prad

  2. #2
    Forum Guru Izandol's Avatar
    Join Date
    03-29-2012
    Location
    *
    MS-Off Ver
    Excel 20(03|10|13)
    Posts
    2,581

    Re: Pivot table week grouping date format

    This is not possible. All of the original formats are ignored and the grouped field is text so it may not use a date format. The only way it may be done is to create a custom grouping field in your data source that is formatted in your desired fashion.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Pivot Table grouping by date
    By sm6132 in forum Excel General
    Replies: 4
    Last Post: 05-04-2010, 12:15 PM
  2. Pivot Table Date Grouping?
    By DangerMouse in forum Excel General
    Replies: 5
    Last Post: 01-18-2007, 12:24 PM
  3. PIVOT TABLE DATE GROUPING
    By Tufail in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-13-2006, 12:25 AM
  4. Grouping By Date in Pivot Table
    By Shams in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 12-07-2005, 03:20 PM
  5. [SOLVED] Date Format Pivot Grouping
    By Easton in forum Excel General
    Replies: 1
    Last Post: 03-08-2005, 09:06 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1