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)
Haytham Amairah
Dec 01, 2017Silver Contributor
Randy,
Try this:
=IF(G3+1>52,1,G3+1)