Next Week Number

[kivanct]

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 

[ouaelaam · Accepted solution]

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 & "."
)

[ouaelaam · Accepted solution]

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 · Accepted solution]

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 

[TomMartens]

Hey @kivanct, 

what is your expectation?

Regards,

Tom