Forum Discussion

Randy Grinsven's avatar
Randy Grinsven
Copper Contributor
Dec 01, 2017

IF funtion with weeknumbers

I am creating a planningscheme and want to creat a format which I can use or each new project. I want the scheme to start with the current weeknumber at the moment I creat it so I use:
=(weeknumber(today)) this is cel G3

I want the cel next to it H3 to be the next number in line by using =(G3+1), this works ofcourse until I reach week 52, from then I want it to automaticly change to 1. I tried this by using:

=IF(G3=52, 1;G3+1)       but this doesn't seem to work.

Resources