Forum Discussion
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
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 & "."
)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
Hey kivanct,
what is your expectation?
Regards,
Tom