Week numbers
Eliminate Pivot Table Annoyances
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 9 of 9

Thread: Week numbers

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

    Default

     
    Hi there,

    We use excel workbooks to report our time in our project. Each person updates his excelfile every friday. In this workbook there are columns for every week and they are numbered 1-52 as the 52 weeks of the year.
    Now to my question:
    How can I get the total hours of the current week in the same cell, without the previous weeks time included, when that is different column every week?

    Thanks guys,
    /// Boo Engstrand ///


  2. #2
    Rest in Peace
    Join Date
    Feb 2002
    Posts
    1,582
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi Boo


    I am not sure I understand your table layout or where this "Same cell" is but have you tried the SUMIF function?

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

    Default

    No, I have not.
    I guess that could work, but only if I can get "todays date" and place that in a week number. Is there a function in excel that keeps track of the week numbering?

    Thanks for your help!
    // Boo //

  4. #4
    Board Regular
    Join Date
    Feb 2002
    Location
    Perth Australia
    Posts
    1,579
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi there
    In Excel 2000 there is a function called weeknum that will give you the week number. So you can use the formula =today() in one cell and have the formula =weeknum refer to it to give the number of the week.
    regards
    Derek


    [ This Message was edited by: Derek on 2002-04-08 04:41 ]

    [ This Message was edited by: Derek on 2002-04-08 04:42 ]

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

    Default

    Hi Derek,

    Sounds like a great function. just what I need. Too bad that I can't change from Excel 97 to Excel 2000. Any ideas to handle that?
    // Boo //

  6. #6
    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-04-08 07:27, booiboa wrote:
    Hi Derek,

    Sounds like a great function. just what I need. Too bad that I can't change from Excel 97 to Excel 2000. Any ideas to handle that?
    // Boo //
    The WEEKNUM worksheet function can be used in Excel 97 once the Analysis ToolPak add-in has been added. See the Help Index topic for "Install and use the Analysis ToolPak".

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

    Default

    OK, thanks!

    How do I format the cell with this formula?
    When I put =WEEKNUM in the cell the output is:
    -640155557

    I sort of expected something like w.12 but I could not find any good formatting on it.
    // Boo //

  8. #8
    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-04-08 08:52, booiboa wrote:
    OK, thanks!

    How do I format the cell with this formula?
    When I put =WEEKNUM in the cell the output is:
    -640155557

    I sort of expected something like w.12 but I could not find any good formatting on it.
    // Boo //
    See the Excel Help topic for WEEKNUM worksheet function.

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

    Default

      
    Thanks!

    Now I see... ;D
    // Boo //

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
  •  

 

 
DMCA.com