# weeknum

#### avinashraste

##### Board Regular
Dear friends,

I want to use weeknum function for the entries from 1st of September. But I want the entries, starting from 1st of September as Week 1.

Where as the function returns the week number 35. So my query is, can we have customized weeknum ? I mean, can I start 1st Of September as Week 1 and then Week 2 from September 8 and so on ?

Regards,
AR

### Excel Facts

Formula for Yesterday
Name Manager, New Name. Yesterday =TODAY()-1. OK. Then, use =YESTERDAY in any cell. Tomorrow could be =TODAY()+1.

#### Scott Huish

##### MrExcel MVP
With date in A1, does this work for you?

=WEEKNUM(EDATE(A1,-8))

#### avinashraste

##### Board Regular
With date in A1, does this work for you?

=WEEKNUM(EDATE(A1,-8))

Dear Scott Huish,

First of all thank you very much for the kind reply.
The solution you've suggested worked like a charm. Thank you very much once again for this reply with fantastic solution.

Regards,
AR

#### avinashraste

##### Board Regular
Dear friends,

I want to use weeknum function for the entries from 1st of September. But I want the entries, starting from 1st of September as Week 1.

Where as the function returns the week number 35. So my query is, can we have customized weeknum ? I mean, can I start 1st Of September as Week 1 and then Week 2 from September 8 and so on ?

Regards,
AR

Dear Scott,

Your suggestion worked very well ( You have suggested "=WEEKNUM(EDATE(A1,-8)" ) with the date 01/09/2017 as week 1.

What can I do if I want to keep 28/12/2017 as week 1 ?

Thanks & Regards

A Raste

#### Nishant94

##### Well-known Member
 A B 1 28-12-2017​ 1 2 05-01-2018​ 2 3 10-01-2018​ 2 4 14-01-2018​ 3

<tbody>
</tbody>

In A1:
Code:
``=int(max(1,a1-\$a\$1)/7)+1``

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

1,168,068
Messages
5,857,146
Members
431,858
Latest member
mucut

### 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.

### Which adblocker are you using?

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

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