Thanks Thanks:  0
Likes Likes:  0
Page 3 of 5 FirstFirst 12345 LastLast
Results 21 to 30 of 47

Thread: HOW DO U MAKE 2 dates STick together to make a WEEK LIKE 21/

  1. #21
    Board Regular
    Join Date
    Mar 2002
    Posts
    122
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    ...

  2. #22
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Sami, I think we "beat this one to death". You don't seem interested in using a PivotTable as was suggested repeatedly.

  3. #23
    Board Regular
    Join Date
    Mar 2002
    Posts
    122
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    what do u guys mean???? i should make a pivot table for the week date and sales (will it group them???)

  4. #24
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Sunny, spring-like Hull
    Posts
    3,339
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Yes and Yes . Have a look on the mrexcel.com website for details of how to set up a pivot table and group items.

  5. #25
    Board Regular
    Join Date
    Mar 2002
    Posts
    122
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    but the sales data needs to be groped by week. plzzzzzzzzz ive been working on this for 8 hourssss flat and im sick to death of this project!!!
    can any one give me anycodes??? i have what the sales workbook looks like in another one of my messages and the accounts is just 2 colums week date and sales revenue. PLEASE!!!

  6. #26
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Sunny, spring-like Hull
    Posts
    3,339
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    You can group your data by weeks. Create your pivot table, stick the Date as a row or column field with your sales as the data field. When you're done, right-click on the date heading in the pivot table, select Group and Outline- Group click on Days and set the number of days to 7 with the spin button at the bottom.

  7. #27
    Board Regular
    Join Date
    Mar 2002
    Posts
    122
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    thanks a lot ill try that

  8. #28
    Board Regular
    Join Date
    Feb 2002
    Location
    Ahmedabad Gujarat
    Posts
    303
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Friend,
    I have a example file of a pivotal table explaning how to group the data.
    YOu can download that file from from my guest download section.

    http://www.pexcel.com/guestdownload

    the file is against the name of "daniel"

    Type of example "Pivotal Chart example"

    i think he had a same problem like you

    ni****h desai

  9. #29
    Board Regular
    Join Date
    Mar 2002
    Posts
    122
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    hey that link doesnt work???

  10. #30
    Board Regular
    Join Date
    Feb 2002
    Location
    Ahmedabad Gujarat
    Posts
    303
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Try again sami it does work.
    ni****h desai

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
  •