Forum Discussion

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

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...
  • Haytham Amairah's avatar
    Dec 01, 2017

    Randy,

     

    Try this:

    =IF(G3+1>52,1,G3+1) 

Resources