+ Reply to Thread
Results 1 to 2 of 2

Pivot table: Grouping by Days

  1. #1
    Registered User
    Join Date
    03-07-2012
    Location
    Reading, England
    MS-Off Ver
    Excel 2010
    Posts
    99

    Pivot table: Grouping by Days

    Hi,

    When I group a date field by Days, it shows date as 2-Oct, 3-Oct, etc, but omits the year. I also was choosing dd/mm/yyyy format, but it keeps 2-Oct without any changes.

    How can I see 2-Oct as 2-Oct-2015?

    Regards

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2504
    Posts
    13,622

    Re: Pivot table: Grouping by Days

    Are they real dates or text looking like dates. You can check this with the ISNUMBER or the TYPE function

+ 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. Replies: 1
    Last Post: 07-22-2015, 07:16 AM
  2. Replies: 1
    Last Post: 05-23-2015, 09:02 AM
  3. Pivot table grouping
    By drewbizz in forum Excel General
    Replies: 1
    Last Post: 02-05-2012, 02:20 AM
  4. Excel 2007 : Pivot Table Grouping
    By mattydalton in forum Excel General
    Replies: 4
    Last Post: 04-22-2010, 06:26 AM
  5. Pivot Table Grouping
    By penumbra547 in forum Excel General
    Replies: 2
    Last Post: 05-28-2009, 12:00 AM
  6. Pivot table grouping
    By SER01 in forum Excel General
    Replies: 3
    Last Post: 11-06-2007, 02:54 AM
  7. [SOLVED] Grouping in Pivot Table
    By Piotr in forum Excel General
    Replies: 2
    Last Post: 05-17-2005, 03:06 PM

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