Forum Discussion
Randy Grinsven
Dec 01, 2017Copper Contributor
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...
- Dec 01, 2017
Randy,
Try this:
=IF(G3+1>52,1,G3+1)
SergeiBaklan
Dec 14, 2017Diamond Contributor
Just in case
=MOD(G3-1,52)+1