Forum Discussion

kivanct's avatar
kivanct
Helper I
3 years ago
Solved

Next Week Number

Hi,

I am trying to reach nextweek number by adding +1, but I got Week 53.

How can i receive NEXT WEEK NUMBER ? Thanks a lot for your help.



Regards 

Need Help
Show and Tell
Tips and Tricks
  • ouaelaam's avatar
    ouaelaam
    3 years ago

    You can create a simple IF condition to move to week 1 when you reach week 52, like this :

    NEXT WEEK = IF(
    WEEKNUM (TODAY (),21) = 52, "1.",
    WEEKNUM (TODAY (),21) + 1 & "."
    )

  • kivanct's avatar
    kivanct
    3 years ago

    Thanks a lot. 

    After some research i also found this formula which works too, 

    NEXT WEEK = WEEKNUM ( TODAY ( )+ 7, 21) & "."  
    that also returns "WEEK 1", if current week is 52. 

    Regards
    that returns 

3 Replies

  • ouaelaam's avatar
    ouaelaam
    Resolver I
    3 years ago

    You can create a simple IF condition to move to week 1 when you reach week 52, like this :

    NEXT WEEK = IF(
    WEEKNUM (TODAY (),21) = 52, "1.",
    WEEKNUM (TODAY (),21) + 1 & "."
    )

    • kivanct's avatar
      kivanct
      Helper I
      3 years ago

      Thanks a lot. 

      After some research i also found this formula which works too, 

      NEXT WEEK = WEEKNUM ( TODAY ( )+ 7, 21) & "."  
      that also returns "WEEK 1", if current week is 52. 

      Regards
      that returns