Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Page 1 of 5 123 ... LastLast
Results 1 to 10 of 47

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

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

    Default

    i dont no how u make them stick together n excel recognises them as a week? how do u make weeks? n how do i group the sales data into weeks and put the weekly sales revenue in a workbook?

  2. #2
    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

    Use WEEKNUM worksheet function which is available after the inclusion of the Analysis ToolPak add-in.

    Also, see http://www.mrexcel.com/board/viewtop...c=1016&forum=2 for formulas to calculate week begin and end dates.

    [ This Message was edited by: Mark W. on 2002-03-05 11:24 ]

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

    Default

    sorry but i got to say WTF!!??!?!?!!? what do i press lol?

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

    Default

    hey mark i no u can do this. but the formula in the other thing didnt work. plz tell me how to enter weeks into excel!!!! thanks

  5. #5
    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-06 08:39, Sami wrote:
    hey mark i no u can do this. but the formula in the other thing didnt work. plz tell me how to enter weeks into excel!!!! thanks
    Provide some sample data.

  6. #6
    New Member
    Join Date
    Mar 2002
    Location
    Arizona
    Posts
    13
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    How about this:

    Assume cell A1 contains your first date and cell A2 contains your second date...

    =(month(a1)&"/"&day(a1)&"/"&year(a1)&" - "(month(a2)&"/"&day(a2)&"/"&year(a2))

  7. #7
    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, 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")

    ...but, I wouldn't recommend that you group data on such a long text string when you can use the WEEKNUM worksheet function instead.

    [ This Message was edited by: Mark W. on 2002-03-06 09:44 ]

  8. #8
    New Member
    Join Date
    Mar 2002
    Location
    Arizona
    Posts
    13
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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!



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

    Default

    On 2002-03-05 11:17, Sami wrote:
    i dont no how u make them stick together n excel recognises them as a week? how do u make weeks? n how do i group the sales data into weeks and put the weekly sales revenue in a workbook?
    Which week is 21/02/02-28/02/02?

    If you want to use labels that read (for users) as weeks, e.g., 04/01/02-04/07/02 or rather 04/01/02-04/05/02 (excludes Saturday and Sunday) standing for the kalendarweek 14, you'll have a computational burden to convert this label into a week number. What follows however computes that number:

    =WEEKNUM(LEFT(E2,SEARCH("-",E2)-1))

    The WEEKNUM worksheet function is available if the Analysis Toolpak is activated via Tools|Add-Ins.


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

    Default

    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!

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
  •