+ Reply to Thread
Results 1 to 2 of 2

dates as columns in a pivot table

  1. 04-10-2015, 04:55 PM #1
    ammartino44
    ammartino44 is offline
    Forum Contributor
    Join Date
    08-14-2013
    Location
    LA Baby!!
    MS-Off Ver
    Excel 2007
    Posts
    1,598

    dates as columns in a pivot table

    Hello. I have a pivot table with a bunch of dates as values. How do I sort these as just 1 year instead of seperate months?
    Reply With QuoteRegister To Reply
  2. 04-13-2015, 01:36 AM #2
    NeedForExcel
    NeedForExcel is offline
    Forum Expert NeedForExcel's Avatar
    Join Date
    03-16-2013
    Location
    Pune, India
    MS-Off Ver
    Excel 2016:2019, MS 365
    Posts
    3,873

    Re: dates as columns in a pivot table

    If your dates are in proper date format, you can group those dates..

    Click on any date and select Year..

    Let me know if that helps!
    Cheers!
    Deep Dave
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. How to compare 2 columns of dates - Pivot Table
    By patch in forum Excel General
    Replies: 0
    Last Post: 03-27-2014, 08:56 PM
  2. Pivot Table - 2 columns of dates, count per week
    By ashakespeare in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 09-27-2012, 07:04 AM
  3. [SOLVED] Pivot table - combining two sets (columns) of dates into one set of row labels
    By Angie178 in forum Excel General
    Replies: 2
    Last Post: 05-21-2012, 10:56 AM
  4. Pivot table to count dates from two columns
    By rhk001 in forum Excel General
    Replies: 2
    Last Post: 10-31-2011, 11:40 PM
  5. Pivot table to count dates from two columns
    By zireael in forum Excel General
    Replies: 0
    Last Post: 03-22-2011, 04:38 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1