+ Reply to Thread
Results 1 to 2 of 2

Dates into years and quarters

  1. #1
    Registered User
    Join Date
    11-26-2021
    Location
    england
    MS-Off Ver
    microsoft 365
    Posts
    1

    Dates into years and quarters

    Hi

    i have a pivot and no matter what i do i cant get it into years and quarters so that every quarter and every year has a total.
    The dates seem to be formatted ok.
    ive tried the grouping button which ive always used in the past but that doesnt work...
    any ideas anyone ??
    this has only been an issue since office as updated.
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    01-25-2011
    Location
    Belgium, Alveringem
    MS-Off Ver
    Excel 2003, 2007, 365
    Posts
    1,418

    Re: Dates into years and quarters

    Are you sure that there are no empty/blank cells or strings in your dates ? That's the most important reason.
    Look into your sourcedata, make the column of your dates widther, change the format to number, the horizontal alignment to general.
    All your dates are now numbers and right aligned !!!
    If not so, error
    Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.

+ 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. Graphing using Quarters/Years
    By athomason in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 05-13-2020, 03:34 PM
  2. Months to quarters to years
    By miumamou in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-08-2019, 09:03 AM
  3. Calculating Rolling Sum based on quarters & years
    By Stathissp in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-04-2018, 10:53 AM
  4. Auto Populate quarters by just typing in the number of years
    By sugar_lips in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 08-27-2014, 09:31 AM
  5. [SOLVED] Excel 2010 - Time between dates in years and quarters (.25)
    By undergrads in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-18-2013, 02:16 AM
  6. Replies: 0
    Last Post: 11-28-2007, 06:57 AM
  7. Show quarters and years on x axis of a chart
    By Kacee in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 03-19-2005, 12: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