+ Reply to Thread
Results 1 to 2 of 2

Excel 2007 : Order date chronologically in Pivot Table

  1. #1
    Registered User
    Join Date
    Chicago, IL
    MS-Off Ver
    Excel 2007

    Order date chronologically in Pivot Table

    I have a Pivot Table that is working great except for the fact that the dates are out of order. It is basically ordering everything by month first, day second and year third. The formatt the date is in is MM/DD/YYYY. What i would like is for it to order everything by Year first, Month second and Day third.

    Thanks for any advise you can give me.

  2. #2
    Forum Expert
    Join Date
    MS-Off Ver
    XL2003 / 2007 / 2010

    Re: Order date chronologically in Pivot Table

    Are you sure you have real dates, not text looking like dates ?
    To check this in your source data enter a column testing the date values with the =ISTEXT(cell) function. If it returns true, it is text not dates
    There are several techniques to solve the problem. Post a sample of your data if necessary

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread


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