Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Page 2 of 5 FirstFirst 1234 ... LastLast
Results 11 to 20 of 47

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

  1. #11
    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

    On 2002-03-07 10:40, Sami wrote:
    Hey guys u seem to no ur stuff but erm the problem is i got an accounts worksheet which has weeks and the total sales coloum. there is just 2 coloumns in this worksheet. The sales revenue and week date is taken from the sales worksheet where daily sales are entered. I need to no how excel will group the sales figures by week and paste the week and the sales revenue in the accounts file. Also if say another sale is done and 10 is entered the sales revenue from the week will change automatically.
    Cheers. Thanks for the info. v grateful!
    Add a 3rd column ('Week Num') to your worksheet. The value of this column is determined by =WEEKNUM('Week Date'). Create a PivotTable with your list as it's source and summarize Sales by 'Week Num'.

    If you don't like reporting by week number after creating your PivotTable group 'Week Dates' in blocks of 7 Days.

    [ This Message was edited by: Mark W. on 2002-03-07 12:34 ]

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

    Default

    erm thanks a lot but when i type =weeknum then it comes up with a value like -1788229
    ????
    i only want a week date to b entered!!
    also i dont no how to group the weekly sales and paste them automatically.

    thanks. plz help.
    also u did answer arashs problem!!!! :@

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

    Default

    i look in format cells date. but there is no week option!

  4. #14
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    83,647
    Post Thanks / Like
    Mentioned
    33 Post(s)
    Tagged
    6 Thread(s)

    Default

    On 2002-03-09 00:23, Sami wrote:
    i look in format cells date. but there is no week option!
    I assume that you're trying to use PivotTables as Mark suggested.

    WEEKNUM is a worksheet function, available only if you activated the Analysis Toolpak via Tools|Add-Ins.

    It is used like in

    =WEEKNUM(A1)

    where A1 houses a date.

    Thus, it is not a formatting thing.

    Aladin

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

    Default

    im not using a pivot table. what ive got is an Accounts workbook. This has 2 columns "Week Date" in coulumn A and "Total Sales Revenue" in column B. I would like to know how excel will enter the week date automatically and then get the total sales revenues from the Sales workbook by adding up and grouping the sales by week. Plz accounts is about 30% of projects marks.

  6. #16
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    83,647
    Post Thanks / Like
    Mentioned
    33 Post(s)
    Tagged
    6 Thread(s)

    Default

    On 2002-03-09 00:57, Sami wrote:
    im not using a pivot table. what ive got is an Accounts workbook. This has 2 columns "Week Date" in coulumn A and "Total Sales Revenue" in column B. I would like to know how excel will enter the week date automatically and then get the total sales revenues from the Sales workbook by adding up and grouping the sales by week. Plz accounts is about 30% of projects marks.
    Activate an empty cell, type =, select 10 rows of data from A and B (that is, select A1:B10), hit F9, copy what you see, and post it in the follow-up.

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

    Default

    ok will do thanks!

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

    Default

    it says "that function not valid and highlights "select". isnt there an easier way??? =select(A1:B10)

  9. #19
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    83,647
    Post Thanks / Like
    Mentioned
    33 Post(s)
    Tagged
    6 Thread(s)

    Default

    On 2002-03-10 02:33, Sami wrote:
    it says "that function not valid and highlights "select". isnt there an easier way??? =select(A1:B10)
    "Select" is not a function; it's an action that you yourself must carry out.

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

    Default

    hey....
    Posted: 2002-03-06 11:24
    --------------------------------------------------------------------------------
    Quote:
    --------------------------------------------------------------------------------


    On 2002-03-06 09:42, Mark W. wrote:
    Sami, if what Scott is suggesting satisfies your requirements you might want to use the following instead...

    =TEXT(A1,"mm/dd/yy")&" - "&TEXT(A2,"mm/dd/yy")

    --------------------------------------------------------------------------------



    !Mucho mejor!
    Hey mark! erm this works perfectly but i gotta make excel make this date by not using specific cells like A1 to A2
    i gotta make it just insert the week everyweek n group the sales data to get total sales revenue . got any ideas?????????? how i can do this?
    v much appreciated!

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
  •