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
1	Start date	Current Date	#weeks
2	11/1/2018	2/15/2019	16

<colgroup><col style="width: 25pxpx"><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>

Sheet27

Worksheet Formulas Cell Formula C2 =INT((B2-A2)/7)+1 <thead> </thead><tbody> </tbody>

<tbody>
</tbody>

 

[RedMan7]

Eric,

Thank you very much, this ended up working!

 

[Eric W]

Glad it worked out for you!