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(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.
Randy,
Try this:
=IF(G3+1>52,1,G3+1)
Just in case
=MOD(G3-1,52)+1
- Haytham AmairahSilver Contributor
Randy,
Try this:
=IF(G3+1>52,1,G3+1)