Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Page 2 of 2 FirstFirst 12
Results 11 to 13 of 13

Thread: Converting Imported Data to a Date Format

  1. #11
    New Member
    Join Date
    Dec 2007
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default keeping both dates when doing analysis

    Thanks for your response!

    I just bought the book "pivot table crunching" by MrExcel and look forward to doing my analysis using pivot table charts and tables.

    Both dates are important to determine weekly trends.

    Since I need both dates should I:
    #1 use text a column creating 2 date ranges
    #2 Fomat new column mdy

    or import the start of each week only and do the same?

    I want to be able to show graphs, charts etc using pivot tables but also want the dates in order when doing analysis.

    Thanks again,
    Art

  2. #12
    MrExcel MVP
    Moderator
    Inactive
    Richard Schollar's Avatar
    Join Date
    Apr 2005
    Location
    UK
    Posts
    23,701
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    1 Thread(s)

    Default

    Do TextToColumns>Delimited>Other:"-" as the delimiter>on the next screen choose the Date format ie MDY for both columns. This should give you your dates.
    Richard Schollar

    Using xl2013

  3. #13
    New Member
    Join Date
    Dec 2007
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default pivot table date formatting

    awesome!

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
  •