Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 5 of 5

Thread: Date functions - Extracting simply the year

  1. #1
    Board Regular
    Join Date
    May 2002
    Location
    Telephone City
    Posts
    76
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I have a date in the form mm/dd/yy

    How do I simply extract just the year, so that when I create a pivot table, I dont get all unique entries which are behind the date. I tried formatting, but that doesn't work, the format is ignored and the source date is looked at!

    Thanks

  2. #2
    Board Regular
    Join Date
    Feb 2002
    Location
    Georgia USA
    Posts
    569
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    You could add another column and use =year(A2) to get the year, then use this data in your pivot table

  3. #3
    New Member
    Join Date
    Apr 2002
    Posts
    48
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-05-03 10:00, Bobthebuilder wrote:
    I have a date in the form mm/dd/yy

    How do I simply extract just the year, so that when I create a pivot table, I dont get all unique entries which are behind the date. I tried formatting, but that doesn't work, the format is ignored and the source date is looked at!

    Thanks
    Add a column with the YEAR formula. If your date is in A1, use =YEAR(A1).

    Alternatively, you can create a pivot table using the unique dates and then use the group feature. Right click in the pivot table, choose Group and Outline then Group and select Years in the By box.

    Hope that helps.


  4. #4
    Board Regular
    Join Date
    May 2002
    Location
    Telephone City
    Posts
    76
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I know that my question seamed pretty straight forward, however, I have tried your suggestion, and I'm getting 1905 instead of 2000.

    Any ideas!??

  5. #5
    Board Regular
    Join Date
    Mar 2002
    Location
    Cincinnati, Ohio, USA
    Posts
    6,824
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Your doing something wrong or your date is already 1905...
    The Year function does indeed pull the year from a date...
    Make sure it is a valid date and not text.
    Tom

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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