WEEKNUM Problems

[RedMan7]

Hello Forumers!

I hope this message finds you well. I am currently trying to solve a problem with the WEEKNUM formula...
I need to convert specific dates to week numbers (as the formula works) however, I am wondering if it is possible to edit the formula or add in more items to it so that it starts counting from a specified date...

For instance, the 3rd of December of 2018 is counted as week 49... But can I have it count as Week 5 if I need it by editing the formula? (Other than subtracting 44 from it)?

The main problem with this is that when I go to January 2019, it starts counting from 1 again... Is there a way to make the dates I have for January count as Week 53 and Week 54 etc?

Thanks for this!

 

[Eric W]

Welcome to the Board.

You could create your own weeknum formula:

	A	B	C	D
Start date	Current Date	#weeks

<colgroup><col style="width: 25pxpx"><col><col><col><col></colgroup><thead>
</thead><tbody>
[TD="align: center"]1[/TD]

[TD="align: right"][/TD]

[TD="align: center"]2[/TD]
[TD="align: right"]11/1/2018[/TD]
[TD="align: right"]2/15/2019[/TD]
[TD="align: right"]16[/TD]
[TD="align: right"][/TD]

</tbody>

Sheet27


[TABLE="width: 85%"]
<tbody>[TR]
[TD]Worksheet Formulas[TABLE="width: 100%"]
<thead>[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]
[TH="width: 10px"]Cell[/TH]
[TH="align: left"]Formula[/TH]
[/TR]
</thead><tbody>[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]C2[/TH]
[TD="align: left"]=INT((B2-A2)/7)+1[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]

 

[RedMan7]

Eric,

Thank you very much, this ended up working!

 

[Eric W]

Glad it worked out for you!