Weeknum ()shows 54

[Annk26]

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..
please see below examples

Thank you in advance

	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

 

[mrshl9898]

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]

Hi,

Are you using System 1 or 2 within your WEEKNUM?

 

[Annk26]

Hi,

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