# Weeknum ()shows 54

#### Annk26

##### New Member
Hello All,

I have a question in regards to weeknum() formula. I would like my first day of the week to show Sunday and last day of the week as Saturday. weeknum ()formula does not really work. For example:
1/3/2021 needs to be 1 but weeknum() shows 2..
Or in some cases weeknum () shows week 54..

 Excel Weeks Weeknum Formula Sun-Sat Monday, December 25, 2028​ 53 52 Tuesday, December 26, 2028​ 53 52 Wednesday, December 27, 2028​ 53 52 Thursday, December 28, 2028​ 53 52 Friday, December 29, 2028​ 53 52 Saturday, December 30, 2028​ 53 52 Sunday, December 31, 2028​ 54 1

 Excel Weeks Weeknum() Formula Sun-Sat Thursday, December 31, 2020​ 53 53 Friday, January 1, 2021​ 1 53 Saturday, January 2, 2021​ 1 53 Sunday, January 3, 2021​ 2 1 Monday, January 4, 2021​ 2 1 Tuesday, January 5, 2021​ 2 1 Wednesday, January 6, 2021​ 2 1

### Excel Facts

Wildcard in VLOOKUP
Use =VLOOKUP("Apple*" to find apple, Apple, or applesauce

#### mrshl9898

##### Well-known Member
With the week ending Sat (eg. Week 1 2021 being the 1st and 2nd) then week 2 starts on the 3rd.

Then with Week 1 being only the 1st of Jan 2028 it does include week 54.

Maybe show us what you would like to see instead so an alternative method can be supplied.

#### jtakw

##### Well-known Member
Hi,

Are you using System 1 or 2 within your WEEKNUM?

#### Annk26

##### New Member
Hi,

Just WEEKNUM. I have tried, 1, 2 , 21. None of them work unfortunately.

Replies
1
Views
414
Replies
12
Views
689
Replies
5
Views
91
Replies
1
Views
262
Replies
6
Views
219

1,141,773
Messages
5,708,453
Members
421,570
Latest member
BaileyJ

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