Results 1 to 3 of 3

Thread: Weeknumber back to 1 after 52

  1. #1
    Board Regular
    Join Date
    Mar 2006
    Location
    West Sussex UK
    Posts
    149
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Weeknumber back to 1 after 52

    Hi all, can anyone help with my query please.

    On our SS Columns AH2 onward contain data in week numbers, but it does not stop at 52 & revert back to week 1 for the new year

    Below is the formula in AH2, cell AH3 = AH2+1, cell AH4 = "AH3+1" and so on

    =INT((TODAY()-WEEKDAY(TODAY(),2)-DATE(YEAR(TODAY()+4-WEEKDAY(TODAY(),2)),1,4))/7)+2


    does anyone know how I can change this to default back to week 1 after 52?

    Thank you

  2. #2
    Board Regular
    Join Date
    Nov 2003
    Location
    Notts, UK
    Posts
    565
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Weeknumber back to 1 after 52

    In AH3 try

    =IF(AH2+1>52,1,AH2+1) and copy down

  3. #3
    Board Regular
    Join Date
    Mar 2006
    Location
    West Sussex UK
    Posts
    149
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Weeknumber back to 1 after 52

    Thank you

Some videos you may like

User Tag List

Tags for this Thread

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
  •