Hi

I'm trying to produce a cell that displays the week number one week from now.
I already have the previous week displayed using the formula: ="Week "&(WEEKNUM(NOW()-1))&" Pay"
For some reason, using the formula ="Week "&(WEEKNUM(NOW()+1))&" Pay" is just returning the current week number.

Thanks in advance for your help.