<div>
Try this.<br />
=WEEKNUM(A2)+(MOD(WEEKNUM(<wbr />A2),2)=0)
</div>


Try this.
=WEEKNUM(A2)+(MOD(WEEKNUM(A2),2)=0)

<div>
You could also adjust when the week starts. See <a href="https://support.office.com/en-us/article/WEEKNUM-function-e5c43a03-b4ab-426c-b411-b18c13c75340" rel="ugc">this article.</a>
</div>


You could also adjust when the week starts. See this article. [https://support.office.com/en-us/article/WEEKNUM-function-e5c43a03-b4ab-426c-b411-b18c13c75340]

<div>
Hi Rgonzo1971. That did it. Thanks<br />
<br />
Hi Norie, I thought yours worked however it's counting Saturdays as in the next week instead of the week that the preceding friday is in. For example, 16 Jan 2016 is a Saturday in week number 3. Your formula produced a 5 (assumed it counted it as week 4 and added the +1). This was consistent each week. <br />
<br />
Hi Martin, Thanks for the suggestion but am trying to align data with 2 week periods so not what I was after. <br />
<br />
Thanks all for responding. <br />
<br />
Best regards, <br />
<br />
swjtx99
</div>


Hi Rgonzo1971. That did it. Thanks

Hi Norie, I thought yours worked however it's counting Saturdays as in the next week instead of the week that the preceding friday is in. For example, 16 Jan 2016 is a Saturday in week number 3. Your formula produced a 5 (assumed it counted it as week 4 and added the +1). This was consistent each week.

Hi Martin, Thanks for the suggestion but am trying to align data with 2 week periods so not what I was after.

Thanks all for responding.

Best regards,

swjtx99

<div>
<div class="content wysiwyg-content">
Hi, I have a simple formula in a cell. <br />
<br />
Weeknum(A2)<br />
<br />
When (IF) the value returned is an even number, I want the result returned to be +1.<br />
<br />
In other words if the Weeknum returned is 2, I want to add 1 so it returns a 3.<br />
<br />
Thanks in advance,<br />
<br />
swjtx99
</div>
</div>


Hi, I have a simple formula in a cell. 

Weeknum(A2)

When (IF) the value returned is an even number, I want the result returned to be +1.

In other words if the Weeknum returned is 2, I want to add 1 so it returns a 3.

Thanks in advance,

swjtx99

+1 to an even value

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.