WEEKNUM Problems

RedMan7

New Member
Joined
Feb 15, 2019
Messages
20
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!
 

Excel Facts

Round to nearest half hour?
Use =MROUND(A2,"0:30") to round to nearest half hour. Use =CEILING(A2,"0:30") to round to next half hour.

Eric W

MrExcel MVP
Joined
Aug 18, 2015
Messages
11,133
Welcome to the Board.

You could create your own weeknum formula:

ABCD
1Start dateCurrent Date#weeks
211/1/20182/15/201916

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


Worksheet Formulas
CellFormula
C2=INT((B2-A2)/7)+1

<thead>
</thead><tbody>
</tbody>

<tbody>
</tbody>
 

Forum statistics

Threads
1,136,909
Messages
5,678,517
Members
419,768
Latest member
eguechi09x

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top